Excel help & learning - support.microsoft.com
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Add or remove items from a drop-down list - Microsoft Support
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you.
Insert, move, or delete page breaks in a worksheet
Add, adjust or remove page breaks in Excel using Page Break Preview. Also, learn how to reset and hide page breaks.
Using IF with AND, OR, and NOT functions in Excel
In Excel, from the Home tab, click Conditional Formatting > New Rule. Next, select the “ Use a formula to determine which cells to format ” option, enter your formula and apply the format of …
Apply or remove cell borders on a worksheet - Microsoft Support
To customize the line style or color of cell borders or erase existing borders, you can use the Draw Borders options. To draw cell borders, you'll first select the border type, then the border …
Insert a horizontal line - Microsoft Support
Tip: Since the line is actually a paragraph, you can create a box by selecting All Borders or Outside Borders.
Apply color to alternate rows or columns - Microsoft Support
Highlight or shade alternate rows of data with colors or patterns to improve the readability of your Excel worksheets.
Keyboard shortcuts in Excel - Microsoft Support
In Excel, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you've copied the data, press Ctrl+Alt+V, or Alt+E+S to open the …
Use conditional formatting to highlight information in Excel
How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.
FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.