Abstract
Transcript
In this video, we’ll look at how to usenamed rangeswithExcel tables.
One problem with tables is that it’s possible for you to’t usestructured referencesdirectly to createdata validationorconditional formattingrules.
To illustrate, here I have a list of projects representing a sales pipeline.
The last column in the table uses data validation to provide a dropdown list of allowed values.
If I make a run at use a structured reference to define the data validation range, Excel complains.
This will let me see at a glance which range is the table.
Next, I’ll create a named range called “Stages” using the name manager.
In the name manager, I’m free to use a structured reference.
When I grab the values in the table, Excel automatically fills in the structured reference.
