Data Validation List From Table. Click in the source box and type an equal sign and the list name for example. So with three options to choose from the question is which is the best.
A1 a12 instead of the column name. On the ribbon s data tab click data validation. Which method to choose.
We simply allow a list equal to the name dd reps as shown below.
Using a single table we need to determine how many rows are used in each column to define the range that we want to present in our data validation list. Using a single table we need to determine how many rows are used in each column to define the range that we want to present in our data validation list. Table1 headers click ok button. You will notice that excel will insert the range reference like.
