You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to whenever you need to. Microsoft Excel's alternative to ...

Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...