It indicates a way to close an interaction, or dismiss a notification.

It indicates a way to see more nav menu items inside the site menu by triggering the side menu to open and close.

This data validation helps prevent mistakes, such as misspellings.

Drop-down lists are also useful for managing data when multiple people use the same spreadsheet.

They keep entries consistent across multiple rows no misspelled words or names written without capitalization.

Drop-down lists are essential if you need to sort your data or create a pivot table.

Check out the products mentioned in this article: Microsoft Office (From 129.99 at Best Buy) Lenovo IdeaPad 130 (From 299.99 at Best Buy) MacBook Pro (From 1,299.99 at Best Buy) How to create a drop-down list in Excel 1.

The first step is to create a list with all the items you want in your drop-down list.

Putting the list entries on the same tab can create confusion.

To create a new tab, click the icon next to the last tab in your spreadsheet.

If they arent, you can convert your list to a table by holding Ctrl T on your PC or command T on your Mac keyboard.

You can also select a whole column.

Click on the Data tab in the top menu so the Data menu ribbon appears.

If you put your list in a separate tab, you can open that tab to highlight the cells.

Hit enter or return on your keyboard to set the range for your list.

Create Dropdown List Excel For Mac