There are written steps on the Create an Excel table page. To see the steps in creating an Excel Table, you can watch this short video.

Another option is a dynamic named range, based on a formula.

Instead of leaving blank cells in the source list, use a dynamic source list that will adjust automatically, when you add or remove items. NOTE: Another problem can occur if there areīlanks in the source list - invalid entries might be allowed When there's a blank cell in the source list, and the cell with theĭata validation list is blank, the list will open with the blank entry The person who set up the list left a few blank cellsĪt the end, where new items could be added. In the example shown above, the drop down list is based on a range Get the sample file in the download section. Why does this happen, and how can you prevent it? Might go to a blank at the bottom of the list, instead of the first

When you click the arrow to open a drop down list on a data entry sheet, the selection Get the Sample Files Drop Down Opens With Blank Selected

No scroll bar in excel 2013