In this video, I will show you how to repeat row and column headers for each page in Excel.
This is especially useful when you’re printing a report that has a lot of data. You can use the method shown in this video to make sure the rows and column headers appear on each page of the printed report.
This can be done by changing a setting in the Page Setup dialog box.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos –
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.
It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
perfect … helped me to recall something I have not used for years
Thanks a lot
how i can do this by VBA
I want to creat row as a header I don't want to my row items show as a master row
Thank you 😀
Thanks!
Thank you ❤️🙏
Thank you for sharing.
How to deactivate I'd is not printed in next sheet…??? please help me
agar se jada title name dalna ho to
Awesome
interesting
this thing is locked in my exel. can anyone help?
Gr8…it works….thnks for ths video…
Thank you Sumit very helpful
this is for printing – but how do you do you creat a new sheet in excell with same headings with out previous data below
Nice, clear video and sound. You kept it short and sweet and easy to follow and understand. Thanks!
HI, CAN WE SEE THE HEADER WHEN WE SCROLL UP N DOWN
Hi sir, how can i put a page number in repeated row and can be saved in one document. I found a vb macro but the document will be save separately according to page no. Hope you can help
useful one.
thankyou very much
Te drecu de detept ca a mers!
thanks
Thank you so much! Super easy when someone shows you how! You are awesome!
I need the headers not to just print but for ease of use.
How to repeat rows on every alternative page?
thank you this helped.
Thanks! That was short & to the point. Good Luck!
thanku very much
legend – thank you!
Pricisly and thoroughly explained. Good job 👌👍
Thank you..got it right first time