An curved arrow pointing right. Data validation in Excel allows you to create drop-down menus right inside individual cells. You can also restrict the types of values entered into different cells.

How to Add Focus Cell to Your Quick Access Toolbar . While Focus Cell is handy for reading and amending spreadsheets ...

Excel will automatically populate instructions to sort data by Column A from A to Z. 6. Click the "Column" drop-down menu to change to Column B (or another column if you have more than two).

Select values that you want to add and select OK. From now on, whenever you enter new data in the column, a drop-down menu ...