How to create column headers in excel

To add a header and footer to your worksheet, follow the next steps:

   1.   Do one of the following:

• On the Insert tab, in the Text group, click Header & Footer:
    or  

  Note: After clicking the Header & Footer button, Excel automatically switches the spreadsheet to the Page Layout view.

• On the View tab, in the Workbook Views group, click Page Layout:

Excel displays the worksheet in Page Layout view, where Excel shows sections Add header and Add footer:

You can also click Page Layout view on the status bar to display this view:

   2.   Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (note that headers and footers consist of three sections: left, center, and right):

Clicking any text box selects the header or footer and displays the Header & Footer tab:

   3.   On the Header & Footer tab,

how to format table headers in excel

how to remove header format in excel