All table names are listed in the Name Box by default Click the drop down list arrow on the top left corner Name Box to display all table namesApr 19, 16 · Click the mouse in the "Name Box" above the cell grid Type a name for the range of cells in the box and press "Enter" For example, we called the selected cells on our "Product Database" worksheet "Products" There are syntax rules you must abide by when choosing a nameJan 07, 21 · Click Insert and then click Text Box Draw the text box in a cell above your table Rightclick the text box and then click Properties Enter the cell number where you drew the box in the LinkedCell field, and then close the window (We used "A3" for this walkthrough) Doubleclick the text box to open Visual Basic module
How To Define Use And Delete Names In Excel Formulas