Specify a header row in a new block of cells you are marking as a table.
- Select the cells you want to include in the table.
- On the Insert tab, in the Tables group, select Table.
- Select the My table has headers check box.
- Select OK.
- Excel creates a header row with the default names Column1, Column2, and so on
- Type new, descriptive names for each column in the table.