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.

7 Resources For Windows 7 Lovers On Vista
Is Windows 7 and Vista the same? Which is better Windows Vista or Windows 7? Why is Windows 7 better than Windows XP and Vista? How can I upgrade Wind...
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...
Quickly Hide Files And Folders In Windows 8 With Keyboard Shortcuts
Step 1 Select the file or folder that you wish to hide. Step 2 Press Alt + V keys to see all options under View tab. Step 3 Lastly, press HS keys to h...