![]() From the menu, select Data > Validation.Select the cell in your table where you want these items to show as a drop-down list.Enter the items for your list in a single column (no blank cells).Go to a blank area of your spreadsheet, outside the table.Now, for all you Excel geeks out there, this is probably no-brainer stuff to you, but I’m an Excel novice so I was really delighted to learn how to do this. I learned a new trick in one of Mike Hughes’ sessions at the WritersUA Conference in March - how to create a drop-down list of valid values in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |