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:
#Excel #ExcelTips #Excelin2Minutes
Nguồn: https://akbarmontada.com/
Xem thêm bài viết: https://akbarmontada.com/category/cong-nghe
Thanks Sumit for videos. they are indeed very helpful.
cheers!
I love your videos as they're in English and absolutely to the point. Thank you.
Hi Sumit.. thanks for these great printing tips that all should know. I often get workbooks from clients without this basic setting place which is frustrating. I'll refer clients to this video to educate them :)) Thanks and Thumbs up!
Sumit Sir,
A very useful one in daily routine work. ; )
Sir when I open view tab under page layout option what's the use of custom views option and what is the use and how it works
In view ta
Sir What's difference between rows to repeat at top and row and column headings in print option of four boxes pl. Clear doubt