Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)
Description
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://courses.xelplus.com
✉ 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
Comments