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.