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.

❤ 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

[ExcelatWork]

Need to learn how to set row one to print at the top of every page? Let Sharyn show you how.

[Zaonite]

Seriously, thank you so much for this! These tutorials are worth their weight in gold.

[Pest-ControlNZ]

Thanks, your videos. They are easy to follow and have saved me hours of head scratching. I apperciate your input. Kind regards.

[FLAMENCODELACOSTA]

THANK YOU THIS WAS EXACTLY WHAT i NEEDED!!!

[bhavnavival]

Thanks for this video. Its very helpful

[melissavillarroel]

Love this, Can you help me set row 1 to print above every row in a table