AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() ![]() Now, we’re going to name our range of cells to make it easier to add them to the drop-down list. You can also add your list of options to a different worksheet in the same workbook. We entered our age ranges into cells A9 through A13 on the same worksheet, as shown below. Just FYI- I am working in Excel for Mac 2011. I regularly use dropdowns to make Excel-based reports more dynamic - enabling the user to choose. ![]() Change the Allow dropdown to List Enter the values in the Source box (separating different values using commas). Originally written by Tim Wilson on May 10, 2011. To begin, enter the list of age ranges into sequential cells down a column or across a row. We’re going to create a drop-down list with a selection of age ranges to show you how it’s done. Drop-down lists are created using the Data Validation feature. It’s easy to add a drop-down list to a cell in Excel, but the process is not intuitive. ![]()
0 Comments
Read More
Leave a Reply. |