Printing an Excel spreadsheet can be difficult when the data that you have is not ideally suited for a piece of paper.
It can be helpful to copy the top row to every page in Excel 2013 when your document is going to span multiple pages, but the method in that article can be a little difficult to recall if you do not do it frequently.
Another way that you can repeat a row at the top of every page is with a button called “Print Titles.”
Excel refers to a row that repeats on every printed page as a title, so familiarizing yourself with that terminology, and using a readily-accessible button, can make it a much simpler method to repeat.
Printing Titles in Excel 2013
The result of this tutorial will be a row of cells that repeats at the top of every page that you print from your worksheet.
If there are other worksheets in your workbook, this setting will not apply to them unless you are working with grouped worksheets.
here is how to print titles at the top of every page in an Excel 2013 spreadsheet –
- Open your spreadsheet in Excel 2013.
- Click the Page Layout tab at the top of the window.
- Click the Print Titles button in the Page Setup section of the ribbon.
- Click inside the Rows to repeat at top field, click the row number that you wish to print at the top of every page, then click the OK button at the bottom of the window.
These steps are repeated below with images –
Step 1: Open your Excel 2013 worksheet.
Step 2: Click the Page Layout tab above the ribbon at the top of the window.
Step 3: Click the Print Titles button in the Page Setup section. This opens a new Page Setup window.
Step 4: Click inside the Rows to repeat at top field, click the number of the row that you wish to repeat at the top of each printed page, then click the OK button at the bottom of the window. You should see something similar to the $1:$1 shown in the picture below.
Now that you know how to print titles in Excel 2013, you can use this option to make it easier for your spreadsheet readers to identify the information in your cells.
If you notice that only part of your spreadsheet is printing, then there might be a print area that you need to clear first.
There is another repeatable location on a printed Excel worksheet called the header. Learn how to display the file name in the header, or use it for other information like the title of the report or your name.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.