Printing the same row at the top of every page in an Excel spreadsheet provides a simple way for people to know what type of data they are reading once they progress beyond the first page.
You may have previously tried to do this manually, which can be remarkably frustrating if you need to delete, add, or otherwise reorganize data.
Fortunately, it is a setting that Excel 2013 allows you to apply automatically.
You can learn about another setting that’s helpful when you’re trying to print a spreadsheet. Our how to fit all columns on one page in Excel tutorial can make it much easier to fit your data on the printed page.
Step 1: Open your spreadsheet in Excel 2013.
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, then click the row number containing the cells that you wish to repeat at the top of every page.
Step 5: Click the OK button at the bottom of the Page Setup window to save your changes.
Now that you know how to repeat a row at the top of every page in Excel 2013, you can make it much easier for people to identify data in your cells and columns.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.