Repeat ROW and COLUMN Headers on Each page in Excel

preview_player
Показать описание
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

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.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

Thank you for this! Every other video I found focused on headers for tables. This was exactly what I was looking for and was straight to the point. Well done!

Paddlerunner
Автор

Thank you for a concise and perfectly articulated educational video... great work !!!!

murshedalam
Автор

Very helpful video! Short, sweet, and to the point

davisrussell
Автор

Brilliant, exactly what I needed, and simply & easily explained. Thank You from the UK

matthewfrostmedia
Автор

Half speed playback worked perfectly since don't use often.thanks!

Otura
Автор

Thank you !! That was driving me nuts ; Trying to figure how to correct a problem with the wrong line repeating itself ... Short, to the point video with clear explanations !! 5 stars !!

michelaudette
Автор

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

CDeeThinks
Автор

Thank you very much for such a helpful video! You saved me the headache of poking around and trying to figure things out! Perfect explanation!

esazonova
Автор

Pricisly and thoroughly explained. Good job 👌👍

shreejisales
Автор

Thank you. You provided the answer I have been looking for.

briank
Автор

Thanks for being so clear and concrete 🙂

adrys
Автор

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

brianmorrison
Автор

thank you... it's very useful for me

karthikapalani
Автор

Thank you for making it so easy to understand!

sylviakelly
Автор

Simple & precise useful explanation. Thanks.👍

kentkamande
Автор

Thanks! it was exactly what I was searching for

AnujSharma-gnim
Автор

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

davemitchem
Автор

Thanks mate! Very simple to follow. Cheers!

DanielOrellana
Автор

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

roshananantpatil
Автор

thanks this is what i was looking for!

augus