First, select the heading cell, and the cells that you want to name Then, on Excel's Formulas tab, click the Create From Selection command Check the box to tell To assign a name to a range of cells, select the cells you want to name The cells don't have to be contiguous To select noncontiguous cells, use the "Ctrl" key Then, click on the Design tab on Excel's ribbon On the left side of this menu, find the Table Name box and type in a new name for your table Make sure that
Excel Tables As Source For Data Validation Lists My Online Training Hub
