
Start a new line of text inside a cell in Excel - Microsoft Support
Insert a line break to start a new line of text or add space between lines of text in a cell in Excel.
Use AutoSum to sum numbers in Excel - Microsoft Support
Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM …
Insert one or more rows, columns, or cells in Excel for Mac
Hold down CONTROL, click the selected cells, then on the pop-up menu, click Insert. On the Insert menu, select whether to shift the selected cells down or to the right of the newly inserted cells.
Ways to add values in an Excel spreadsheet - Microsoft Support
One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data, then on the Formula tab, select AutoSum > Sum.
Insert comments and notes in Excel - Microsoft Support
You can add comments to cells. When a cell has a comment, an indicator appears in the corner of the cell. When you hover your cursor over the cell, the comment appears.
Insert bullets in a worksheet - Microsoft Support
Add a bullet to a cell in a worksheet using character codes or symbols. In addition to a round bullet, you can choose to add a checkbox or other symbol.
Combine text and numbers - Microsoft Support
To display both text and numbers in a cell, enclose the text characters in double quotation marks (" "), or precede the numbers with a backslash (\). NOTE: Editing a built-in format does not remove the format.
Add or change the background color of cells in Excel
You can highlight data in cells by using Fill Color to add or change the background color or pattern of cells. Here's how: Select the cells you want to highlight. Tip: To use a different background color for …
Create a drop-down list - Microsoft Support
Ideally, you'll have your list items in an Excel table. If you don't, then you can quickly convert your list to a table by selecting any cell in the range, and pressing Ctrl+T.
Use the SUM function to sum numbers in a range
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers.