Repeat ROW and COLUMN Headers on Each page in Excel



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

5/5 - (1 bình chọn)

Bài viết liên quan

Theo dõi
Thông báo của
guest
31 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
Brian Morrison

perfect … helped me to recall something I have not used for years

Ye Matias

Thanks a lot

العرندس

how i can do this by VBA

rohit Gupta

I want to creat row as a header I don't want to my row items show as a master row

Satyam Saboo

Thank you 😀

Julio Lebron

Thanks!

vann ordonia

Thank you ❤️🙏

Constantine Isslamow

Thank you for sharing.

Sandhya Tripathi

How to deactivate I'd is not printed in next sheet…??? please help me

Mukund Badnerkar

agar se jada title name dalna ho to

Carlos Francisco Roque Valdez

Awesome

nangue galbert

interesting

Anshumaan Bhagat

this thing is locked in my exel. can anyone help?

Diwakar Zalte

Gr8…it works….thnks for ths video…

Miguel Lomeli

Thank you Sumit very helpful

luisa

this is for printing – but how do you do you creat a new sheet in excell with same headings with out previous data below

Sunshine Rose

Nice, clear video and sound. You kept it short and sweet and easy to follow and understand. Thanks!

STUDY LINK

HI, CAN WE SEE THE HEADER WHEN WE SCROLL UP N DOWN

siti farahiyah

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

Sundaram Saravanan

useful one.
thankyou very much

Dublu Em

Te drecu de detept ca a mers!

vandavasi cms

thanks

Dave Mitchem

Thank you so much! Super easy when someone shows you how! You are awesome!

donna anasse

I need the headers not to just print but for ease of use.

Amay Kumar

How to repeat rows on every alternative page?

Humphrey Makere

thank you this helped.

Roshan Anant Patil

Thanks! That was short & to the point. Good Luck!

Raj Dutta

thanku very much

Shaz Edwards

legend – thank you!

Shreeji Sales

Pricisly and thoroughly explained. Good job 👌👍

Lakshmi Arora

Thank you..got it right first time