Excel displays the worksheet in Page Layout view. 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 …

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 …

In a worksheet that will take more than one page to print, you can print column headers on each page so the column headings can be seen on each page. On the Page Layout tab, in the …

You can set up the table so that the table header row or rows appear on each page automatically. You can choose from two ways to set up your table so that its header row or rows repeat.

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.

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 & …

If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the …

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 …

By default, Excel doesn't print the column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) that appear along the borders of the sheet. Follow these steps to print the column and row …

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 …