![how to lock cells in excel keyboard shortcut mac how to lock cells in excel keyboard shortcut mac](https://media.idownloadblog.com/wp-content/uploads/2020/09/Excel-Mac-Select-Sheet.jpg)
Click “OK” and your list will be updated. In the Source box, add new list items to the list or remove the ones you no longer want. Select the cell containing the drop-down list, go to the Data tab, and choose “Data Validation” in the Data Tools section of the ribbon.
How to lock cells in excel keyboard shortcut mac how to#
RELATED: How To Restrict Data Input In Excel With Data Validation
![how to lock cells in excel keyboard shortcut mac how to lock cells in excel keyboard shortcut mac](https://cdn.ablebits.com/_img-blog/scroll-lock/scroll-lock-status-bar-excel.png)
If you entered your list items manually in the Data Validation box rather than referencing a table or cell range, you can simply add or remove list items in that same spot. If you simply select the cell and delete the text in it, you’ll see a blank space in your list as shown below. When prompted, select “Shift Cells Up” and click “OK.” To remove a list item in the cell range, right-click and choose “Delete.” Note: If you use a named range, you may want to update the cell references as described above. Whether you use a named range for your drop-down list or a cell range without a name, removing an item from the list works the same way. Your drop-down list automatically updates to include the new list item. Click the checkmark to the left of that field to save your changes and hit “Close.” You can manually adjust the cell references or simply drag through them on your sheet. When the Name Manager opens, select the named range and update the cell references in the Refers To box at the bottom. Go to the Formulas tab and select “Name Manager” in the Defined Names section of the ribbon. However, this will not update the named range to include the additional item. If you use a named range for your list items, you can use the above method to add an item to the list. Optionally, check the box at the bottom if you use the list in more than one place and want to update it throughout.