![]() Then, follow the same steps as above beginning with Step 2 for the Data tab and Data Validation button. Select the entire column by clicking the letter at the top or the entire row by clicking the number on the left. 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.Īdd a drop-down list to a column or row If you want to use the same drop-down list options across a whole column or row, this is simple. You can also type in the cell range yourself if youre comfortable with the format.) Note that the pop-up window will minimize as you perform this action.Ĭlick OK. Under Validation criteria Allow, select List.Ĭlick inside the Source box and then drag through the cells that should appear in the drop-down list. In the pop-up window, click the Settings button. Open the Data tab and click Data Validation from your ribbon. You can use a new sheet in your workbook or existing cells where you have the items entered.Ĭlick the cell where you want to insert the drop-down list. Where Is The Text Wrap In Microsoft 2011 Version 14.2.0 Mac Productivity TutorialĪdd a drop-down list to a cell Open Microsoft Excel and the document where you want to add the drop-down list.Įnter your list items onto a spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |