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

Save
2 years ago
23
XelplusVis Leila Gharani Advanced Excel tricks Excel online course Excel tips and tricks Excel for analysts Microsoft Excel tutorials Microsoft Excel Excel 2016 Excel 2013 Excel 2019

2 Jan 2020 Excel Introduction - Learn Excel Basics

Complete Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
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.

⯆ Complete blog post on printing large spreadsheets: https://www.xelplus.com/excel-printing-repeat-header-rows

More Excel printing tips and tricks: https://youtu.be/SZBRFRoGSFY
Complete Excel basics playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Loading comments...