![]() If we use standard cell references, the Data Validation list will be static. The Table name is myList (I know, it’s not a great name, but it will work for the examples). The examples in this post use the following data: Let’s look at each of these and you can decide which is the best option for your situation. What can you use to solve this problem? I’ve got three solutions for you: It should use the column called Animals from a Table called myList.īut Excel will show an error message instead. The following Data Validation settings look like it should work. ![]() Data Validation lists would also benefit from the auto-expand feature… but it just doesn’t work an oversight on Microsoft’s part (in my opinion). A Table can be used as the source data for a chart and within a named range, both of which benefit from the auto-expand feature. This feature alone makes Tables one of the most powerful tools within the Excel users toolkit. ![]() Excel Tables expand automatically whenever new data is added to the bottom.
0 Comments
Leave a Reply. |