drop down option not showing in excel for mac

Drop Down Option Not Showing In Excel Update Automatically With

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.

Drop Down Option Not Showing In Excel Update Automatically With

Its easy to edit a drop-down list if its based on an Excel table, as the table should update automatically with your edits.

If you want to edit a drop-down list based on a cell range, named range, or manual entries, the process will take a few more steps.

If your list is based on an Excel table, then this process is incredibly simple just add or delete the items from the table, and Excel will update the drop-down list for you automatically.

However, if your drop-down list is based on a range of cells, a named range, or was entered manually, the process requires a few extra steps.

Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.

Select the cell that contains the drop-down list, then, in the Data menu at the top of your screen, click Data Validation, and select Data Validation again from the menu.

Add a new item to your list, or delete the one you dont want.

In the settings tab of the pop-up window, under Source, add or delete list items as necessary, making sure all items are separated with a comma and nothing else.

Drop Down Option Not Showing In Excel For Mac