Menu
Step 1: Open the Excel 2013 spreadsheet for which you want to repeat a row at the top of every page, then make sure that you are scrolled to the top of the spreadsheet. Step 2: Click the Page Layout tab at the top of the window.
Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen. This month I’ll show you how you can choose rows or columns to appear on every page when you print. This lets you print a report heading and/or column/row headings on each page without having to actually place them throughout your worksheet. This is all you have to do:
- Click the Page Layout tab on the ribbon.
- Click the Print Titles button in the Page Setup section of the ribbon.
- To get rows from your spreadsheet to appear at the top of every printed page, click in the Rows to repeat at top box. 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.
- To get one or more columns to print on the left side of each page, click in the Columns to repeat at left box, then click on the column or columns you want to have printed on each page.
Here are a couple of additional details. The rows (or columns) to repeat have to be adjacent, for example you can’t select rows 1 and 3, but not 2. Also, you only select entire rows (or columns) to repeat.
The rows you selected don’t have to be at the top of your worksheet – i.e. row 1. Let’s say you have a report heading in rows 1 through 3 and column headings in rows 4 and 5. 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.
To take that example to the extreme, if you selected row 500 at “Rows to repeat at top” it would not begin repeating until the page after the page that row 500 naturally prints on.
The same principle applies to “Columns to repeat at left”.
If You Liked This Post:
![How To Make A Row Print On Every Page In Excel For Mac How To Make A Row Print On Every Page In Excel For Mac](http://i.stack.imgur.com/4qnmY.png)
The Page Break preview feature in Excel 2016 enables you to spot and fix page break problems in an instant, such as when the program wants to split information across different pages that you know should always be on the same page.
This figure shows a worksheet in Page Break Preview with an example of a bad vertical page break that you can remedy by adjusting the location of the page break on Page 1 and Page 3. Given the page size, orientation, and margin settings for this report, Excel breaks the page between columns K and L. This break separates the Paid column (L) from all the others in the client list, effectively putting this information on its own Page 3 and Page 4 (not shown).
![Mac Mac](/uploads/1/2/5/7/125793866/316864045.png)
Preview page breaks in a report with Page Break Preview.
To prevent the data in the Paid column from printing on its own pages, you need to move the page break to a column on the left. In this case, I moved the page break between columns G (with the zip-code data) and H (containing the account status information) so that the name and address information stays together on Page 1 and Page 2 and the other client data is printed together on Page 3 and Page 4.
Page 1 of the report after adjusting the page breaks in the Page Break Preview worksheet view.
This figure shows vertical page breaks in the Page Break Preview worksheet view, which you can accomplish by following these steps:
- Click the Page Break Preview button (the third one in the cluster to the left of the Zoom slider) on the Status bar, or click View→Page Break Preview on the Ribbon or press Alt+WI.This takes you into a Page Break Preview worksheet view that shows your worksheet data at a reduced magnification (60 percent of normal in the figure) with the page numbers displayed in large light type and the page breaks shown by heavy lines between the columns and rows of the worksheet.The first time you choose this command, Excel displays a Welcome to Page Break Preview dialog box. To prevent this dialog box from reappearing each time you use Page Break Preview, click the Do Not Show This Dialog Again check box before you close the Welcome to Page Break Preview alert dialog box.
- Click OK or press Enter to get rid of the Welcome to Page Break Preview alert dialog box.
- Position the mouse pointer somewhere on the page break indicator (one of the heavy lines surrounding the representation of the page) that you need to adjust; when the pointer changes to a double-headed arrow, drag the page indicator to the desired column or row and release the mouse button.For the example shown, the page break indicator was dragged between Page 1 and Page 3 to the left so that it’s between columns G and H. Excel placed the page break at this point, which puts all the name and address information together on Page 1 and Page 2. This new page break then causes all the other columns of client data to print together on Page 3 and Page 4.
- After you finish adjusting the page breaks in Page Break Preview (and, presumably, printing the report), click the Normal button (the first one in the cluster to the left of the Zoom slider) on the Status bar, or click View → Normal on the Ribbon or press Alt+WL to return the worksheet to its regular view of the data.
You can also insert your own manual page breaks at the cell cursor’s position by clicking Insert Page Break on the Breaks button’s drop-down menu on the Page Layout tab (Alt+PBI) and remove them by clicking Remove Page Break on this menu (Alt+PBR). To remove all manual page breaks that you’ve inserted into a report, click Reset All Page Breaks on the Breaks button’s drop-down menu (Alt+PBA).