Aug 18, 2014 - On a new worksheet, type the values that you want to appear in your drop-down list. They should be in a single column or row without any. ![]() I was not able to find such a solution after quite a bit of searching. The best I could find is a kludge but actually works fairly well: 1) In the sheet where you want the dropdown, place a link to the list that resides in another sheet. Put that link in as many rows as you need to capture the entire list. (You could alternatively just put the actual list on the worksheet, but linking to it is good enough.) 2) Put some entry into a continuous series of cells to connect your dropdown cell to the list. The series can be both vertical across multiple rows and horizontal across multiple columns. All that matters is that the cell-to-cell trail is continuous. Screen displays different an cell content in excel for mac. Free download teamviewer remote control. A single space is a good enough entry but if you use a space, I highly recommend filling the background of the cells or otherwise indicating somehow that these 'connector' cells are important. It's extremely difficult to come back years later and figure out a worksheet that relies on cells having spaces in them, since you won't see the spaces unless you know to look for them. 3) Once your linked list is connected to your entry cell by this trail of intervening, non-empty cells, Excel's automatic auto-complete will kick in for your entry cell. You don't need validation or a dropdown box or anything, you just need to have autocomplete turned on, which I think is the default.
0 Comments
Leave a Reply. |