
Insert or delete rows and columns - Microsoft Support
You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.
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.
Using check boxes in Excel - Microsoft Support
If you reference a check box cell with a formula, TRUE or FALSE will be passed along to that formula. For example, if you have a check box in cell A1, you can use a formula like =IF (A1, …
Create a drop-down list - Microsoft Support
You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
Insert Picture in-cell in Excel - Microsoft Support
You can easily switch between the picture types and convert a picture that is floating over cells to a picture in a cell. When selecting a picture over cells and choosing Place in Cell, the picture …
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 …
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.
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 …
Combine text from two or more cells into one cell in Microsoft Excel
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Link a chart title, label, or text box to a worksheet cell
To easily update a chart or axis title, label, or text box that you have added to a chart, you can link it to a worksheet cell. Changes that you make to the data in that worksheet cell will …