Excel highlights the cells above B15, including the blank cell. 3. In the Defined Names group under the Formulas tab, click the Use in Formulas button and select the range name Quantity from the list.

How to create an Excel table. 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.