Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)

Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)

 

 

For larger Excel tables make sure you repeat the table row headers and column headers on every printed sheet. This is important when you print a large Excel spreadsheet on multiple pages. This important Excel Printing option can be found in the Page Layout tab under more options for "page setup". 

 

In the Sheet tab, you'll find an option called "Rows to repeat at top" - select the specific rows on your Excel sheet that you'd like to see on every printed page.  In a similar manner you can use "Columns to repeat at left". Select the columns you'd like repeated on every single printed Excel sheet.  

Related Topics:

• Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)
• Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder 
• Excel ActiveX Combo Box to Select Worksheets with VBA
• Excel VBA FIND Function (and how to handle if value NOT found)