how to make top row print on every page in excel for mac

This month Ill show you how you can choose rows or columns to appear on every page when you print.

Then, with the Page Setup window still open, click on the row of your choice.

You can select multiple rows by clicking on the first row and dragging to select a range of rows.

The rows (or columns) to repeat have to be adjacent, for example you cant select rows 1 and 3, but not 2.

If you select rows 4 and 5 as Rows to repeat at top page 1 will still print as it appears on screen but beginning with page 2, only rows 4 and 5 (not 1-3) will appear at the top of each printed page.

Enter the range for the rows you want to repeat on every page in the Rows to repeat at top edit box.

For example, we want the first row of our spreadsheet to repeat on all pages, so we entered 1:1.

To do so, click the Collapse Dialog button on the right side of the Rows to repeat at top edit box.

The row range is inserted into the Rows to repeat at top edit box automatically.

To expand the Page Setup dialog box, click the Collapse Dialog button again.

To unselect multiple worksheets, click on any other worksheet that is not selected.

If all worksheets are selected, right-click on any of the selected sheets and select Ungroup Sheets on the popup menu.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

How To Make Top Row Print On Every Page In Excel For Mac