To add or edit a header or footer, select the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer).

To rename the columns, double-click each column header and type the name you want or edit an existing one. To return the transformed data to the Excel worksheet, select Home > Close & Load.

On the Home tab in the Font group, set the formatting options that you want to apply to the header / footer. When you're done, click the Normal view button on the status bar.

Add page numbers or other text to a header or footer. Learn what a header and footer is, and how to find them in Excel.

In the Table Style Options group, select the Header Row check box to hide or display the table headers. If you rename the header rows and then turn off the header row, the original values you input will be …

Rotate text and borders in column headings You can angle text to fit long headings into small columns. Select the cells that you want to format. On the Home tab, click Format, and then click Format Cells. …

How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages …

If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles.

When you create an Excel table, Excel assigns a name to the table, and to each column header in the table. When you add formulas to an Excel table, those names can appear automatically as you enter …