The first row of your selection will automatically be converted into column headers.

You can freeze a row so that it always appears on the screen, even if the reader scrolls down the page.

If you want the same header to appear across multiple pages, you can set specific rows and columns to print on each page.

If your data is organized into a table, you can use headers to help filter the data.

You can set Excel to freeze rows and columns so that they are always visible.

To do this, youll want to select the cell in the corner of the area you want to keep unlocked.

All columns to the left will be frozen, and all rows above will be frozen.

This will lock the rows above your selected cell and the columns to the left of your selected cell.

For example, if you had cell B2 selected, the top row and the first column will be locked on the screen.

Create a visual contrast for this row by centering the text in these cells, applying bold text, adding a background color, or drawing a border under the cells.

If you have a large worksheet that spans multiple pages that you need to print, you can set a row or rows to print at the top of every page.

Click the button next to the Print Area field and then drag the selection over the data you want to print.

Dont include the column headers or row labels in this selection.

This will allow you to select the row(s) that you want to treat as the constant header.

The rows that you select will appear at the top of every printed page.

This is great for keeping large spreadsheets readable across multiple pages.

This will allow you to select columns that you want to keep constant on each page.

These columns will act like the rows you selected in the previous step, and will appear on every printed page.

Click the HeaderFooter tab and insert a header andor footer for your print job.

You can include the company title or document title at the top, and insert page numbers at the bottom.

When you convert your data to a table, you can use the table to manipulate the data.

One of the features of a table is the ability to set headers for the columns.

Note that these are not the same a worksheet column headings or printed headers.

How To Insert A Header In Excel For Mac