Drop-down

How to Create a Dropdown List in Microsoft Excel

How to Create a Dropdown List in Microsoft Excel

Create a drop-down list

  1. Select the cells that you want to contain the lists.
  2. On the ribbon, click DATA > Data Validation.
  3. In the dialog, set Allow to List.
  4. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

How To Show/Hide Drive Letters In Windows 7
How To Show/Hide Drive Letters In Windows 7 & Vista Open explorer. ... Go to Organize > Folder and search option. Move to View tab and scroll d...
How To Display Windows 7 Build Number On Desktop
How To Display Windows 7 Build Number On Desktop Open the native Registry Editor by typing regedit in Start menu search area and hitting Enter key. Ne...
How To Perform Right-Click On Windows 8 Tablet
To right-click an item on a Windows 7 or Windows 8 tablet, follow these two simple steps Touch the item with your finger or stylus, and keep the finge...