Select Data Validation.
In the menu, select List. Place the cursor in the Source line in the dialog box. Select OK to close the dialog box and return to the worksheet. Select the cell containing the drop-down list to be removed. Select Data. In the dialog box, select the Settings tab. Excel or Appleworks?
I see all kinds of dependent drop down lists where you select an item and then go to the next column and select another item. In my case I would like to create a dependent drop down list where you select a Hallway example: Hallway 1 in say cell A1, after selecting Hallway 1, I would then click on cell a1 drop down list again and have it show me a list of all the Room Numbers in Hallway 1 being the final result.
How to Use Microsoft Excel. Learn Online.
Cell A1 should now show I am doing this for a High School for Substitute Teachers. Any Help would be greatly appreciated.
Thanks Larry. It will require some VBA code, but I believe it can be done.
Please let me know what version of Excel you are using. Thanks for the challenge, Larry. I am having trouble trying to figure out the formulation in the spreadsheet. In this spreadsheet you select the A-Names and when that comes up, you click on the drop down arrow again and then a list of Names beginning with A appears and you select the name.
- how to print email from hotmail on mac.
- logiciel de caisse gratuit pour mac.
- buy pc games online for mac.
This is the name that will appear in the same drop down list after clicking on the drop down list twice. For some reason which I do not know it does not like numbers???
How to create drop-down lists in Excel on Mac
I tried to stick a letter in front of the number and it works. The pop-up window will disappear and you should see that the cell for your drop-down list contains an arrow for you to select an item. If you want to use the same drop-down list options across a whole column or row, this is simple. Select the entire column by clicking the letter at the top or the entire row by clicking the number on the left. Then, follow the same steps as above beginning with Step 2 for the Data tab and Data Validation button.
Word 2011 for Mac: Insert a Combo Field on a Form
Adding a drop-down list to your spreadsheet is convenient for selecting from several pre-determined items. And, you can create multiple drop-down lists for different items all on one sheet. Is this an Excel feature that you find helpful?
Related insert drop down box excel mac
Copyright 2019 - All Right Reserved