This guide is going to show you how to set row 1 to print on every page. We list the steps at the beginning of the article, but you can continue reading after to see the steps with pictures.
- Open the spreadsheet in Excel.
- Select the Page Layout tab at the top of the window.
- Choose the Print Titles button.
- Click inside the Rows to repeat at top field.
- Select the row 1 heading at the left side of the window.
- Click the OK button.
There are many ways that you can format a printed spreadsheet so that it is easier to read on paper. Our Excel print guide offers many of these solutions, but one of the more commonly used print adjustments involves print the first row of your spreadsheet at the top of every page.
If you have a large spreadsheet that contains many columns with similar types of information, then that information can become much more difficult to read when the reader gets to the second page and loses the identifying column title that appeared on the first page. This can lead to mistakes and misunderstandings, which is something that we want to avoid as spreadsheet creators. So continue reading below and learn how to print the top row of your spreadsheet on every page in Excel 2016.
How to Repeat the Top Row on Every Printed Page of an Excel 2016 Spreadsheet
This guide was written using Microsoft Excel 2016, but is very similar in other versions of Excel as well. And while we are specifically going to focus on printing the top row on every page, you can adjust these steps to print more than one row, or even print a column on each page, if you would prefer.
Step 1: Open your spreadsheet in Excel 2016.
Step 2: Click the Page Layout tab at the top of the window.
Step 3: Click the Print Titles button in the Page Setup section of the ribbon.
Step 4: Click inside the Rows to repeat at top field, click the “1” row number (this should add $1:$1 into the field), then click the OK button.
You can then proceed with printing your spreadsheet as normal, except this time the first row will be at the top of each page.
Have you ever needed to print an empty grid from Excel, but you struggled to get Excel to print cells without data? Learn about printing empty grids in Excel if you find yourself in a situation where it would be helpful.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.