HOW TO Set Row 1 to Print on Every Page in Excel

Set row 1 to print on every page. The Excel Print Titles feature allows you to avoid having to copy and paste column titles where-ever there is a page break. Instead set Print Titles so that your column headings are automatically printed at the top of each page in your Excel worksheet.

Topic #43 in the ‘Steps to becoming Proficient in Excel’ workbook.

👀 the full article here: https://www.excelatwork.co.nz/2021/04...

🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: https://excelatwork.co.nz/subscribe/ 🔔

❤ VERSION FRIENDLY ❤
Try this with 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365.
Sharyn’s using the desktop version of Excel for Office 365 as part of the Office 365 Business Premium subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelatWork