With the range of cells I want to include in the named range selected, I right click and choose Define Name Name the range of cells Because I had no header row, the name is currently blank Name the Range With the region still highlighted, I'll name the range InterfaceCourses and click OK Click File Save and SendSelect the range A1B4, and then click Set Database on the Data menu On the Formula menu, click Define Name In the Name box, type Date In the Refers to box, type "=OFFSET(Database,1,0,ROWS(Database)1,1)" Click Add In the Name box, type Sales In the Refers to box, type "=OFFSET(Database,1,1,ROWS(Database)1,1)" Click Add, and then click OKSelect the range you want to name, including the row or column labels Click Formulas> Create from Selection In the Create Names from Selectiondialog box, select the checkbox (es) depending on the location of your row/column header If you have only a header row at the top of the table, then just select Top row
Excel Pro Tips How To Create Define And Use Named Ranges
