Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)

Рет қаралды 133,178

4 жыл бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Struggling with Excel printouts missing headers and unclear data? For larger Excel tables make sure you repeat the table row headers and column headers on every printed sheet. This is important when you print a large Excel spreadsheet on multiple pages.
Get access to the full Excel Essentials Course here 👉 www.xelplus.com/course/learn-...
This important Excel Printing option can be found in the Page Layout tab under more options for "page setup". In the Sheet tab, you'll find an option called "Rows to repeat at top" - select the specific rows on your Excel sheet that you'd like to see on every printed page.
In a similar manner you can use "Columns to repeat at left". Select the columns you'd like repeated on every single printed Excel sheet.
This video is your solution! Discover how to make every page of your Excel reports clear and easy to understand, perfect for both beginners and advanced users.
What You'll Learn:
- Header Repetition: Easily repeat row and column headers on every page of your printout or PDF, ensuring clarity on each page.
- Sample Data Demonstration: Watch as we apply these techniques to sample profit development data, spanning multiple rows and columns.
- Print Preview Tips: Check your document in Print Preview and see how these changes transform your reports.
- Removing Unwanted Data: Learn how to exclude specific content from your printout without deleting it from your worksheet.
- Setting Print Areas: Highlight and set your desired print area for a more focused report.
- Adding Page Numbers: Follow simple steps to add page numbers and total page counts to your printout, a must for documents over two pages.
- Navigating Views: Switch between Normal View and Page Layout View for better control over your print layout.
⯆ Complete blog post on printing large spreadsheets: www.xelplus.com/excel-printin...
More Excel printing tips and tricks: • How to Properly Print ...
Complete Excel basics playlist: • Excel Introduction - L...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Пікірлер: 117

@LeilaGharani 6 ай бұрын

Discover more practical Excel tricks like the one in this video by joining our full "Excel Essentials" course here 👉 www.xelplus.com/course/learn-excel-essentials/

@j4v33d 4 жыл бұрын

You are an Excel Queen!! I thoroughly enjoy learning from all your content on this channel, can't thank you enough Leila!! Really appreciate it.

@byronstutorialspage2134 4 жыл бұрын

I knew this one! Another way to quickly access the header/footer options is on the INSERT Tab and select the "Header & Footer" option in the "Text" section of the tab. Page Layout and Header & Footer are things I use a lot, so I have actually included both of them in my own Custom Tab to save me going back and forth between Tabs.

@nipunkavinda8254 4 жыл бұрын

Most people got confusions when present a hard copy of a spreadsheet in a complete outlook. You made this mess easier. We learn lot of tricks from you Leila. You are my best teacher of Excel...

@LeilaGharani 4 жыл бұрын

I'm glad to hear that :)

@VishwaManava_Sri 4 жыл бұрын

Wish you and your family, friends and near and dear ones a very happy, healthy and prosperous new year 2020. Keep excelling in EXCEL.

@LeilaGharani 4 жыл бұрын

Thank you! Have a great 2020 yourself.

@lazalazarevic6192 4 жыл бұрын

Great demonstration Leila. Cheers!

@Nik-oy4qf 4 жыл бұрын

You have reinvented the tutorial in simple and concise way, great work 😍

@LeilaGharani 4 жыл бұрын

Thank you for the kind words.

@cmavishnu5003 4 жыл бұрын

One of the best tip from Leila again 👍

@amilcarc.dasilva5665 4 жыл бұрын

Happy New Year Queen Leila Gharani. Your are super. Thanks for sharing your brainy knowledge and skill. You're the QUEEN of Excel.

@user-eq7dk2lk2d 4 жыл бұрын

SWEET QUEEN HAPPY NEW YEAR

@fabianbacaresjriii4676 4 жыл бұрын

Very useful videos as always

@Mamuchonga01 4 жыл бұрын

You are the best Leila.

@indradevdubey 4 жыл бұрын

I just love your explanation ❤️ Please post more videos as it helps us to improve our knowledge and confidence.

@LeilaGharani 4 жыл бұрын

I'll do my best :)

@habukproductions6966 4 жыл бұрын

Excellent work Leila

@botix1979 3 жыл бұрын

Thanks Leila, extremely useful!!!

@enriquedominguez9709 4 жыл бұрын

Thank you Leila. Happy New Year!

@LeilaGharani 4 жыл бұрын

Happy New Year to you too Enrique.

@alinesouzacruz4952 4 жыл бұрын

Thanks for sharing this great tip!

@francisallanlim2535 4 жыл бұрын

happy New Year Leila!....I had considered myself an intermediate Excel User, vlookup then index/match (because of your videos)....however I did not know this feature, I was using the Header Option to be able to print the column headers...your lesson is totally helpful to me...Thanks!

@yulinliu850 4 жыл бұрын

Nice printing tip. Cheers

@vida1719 4 жыл бұрын

Those icons in the bottom right corner are so handy. I always used menu. Now I can navigate faster between print and normal views

@simoiyahector-morales3781 4 жыл бұрын

Happy New Year and thanks for this amazing trick

@LeilaGharani 4 жыл бұрын

Happy New Year to you too Simoiya! Thank you for your ongoing support.

@hong857643210 4 жыл бұрын

This 5-minutes tutorial is priceless, it spares me a lot of time to discover these functions in the hard way. thank you!!!

@LeilaGharani 4 жыл бұрын

Great to hear!

4 жыл бұрын

Close to 300 k subscribes!!! Congratulations in advance! And Happy New Year!

@LeilaGharani 4 жыл бұрын

Thank you! Happy New Year to you too.

@katerina6495 4 жыл бұрын

Hi Leila, das Video ist Wunderschön, so Praktisch und notwendig, Viele liebe Grüße und Frohnes Neues Jahr 💞

@LeilaGharani 4 жыл бұрын

Danke liebe Katerina :) Happy New Year to you too!

@jeceva09 4 жыл бұрын

thanks Leila. This video helped me in my work :)

@lucyelora4214 2 жыл бұрын

Love ur videos🥰

@barttrudeau9237 4 жыл бұрын

I've learned a lot from your past videos. This one is very basic. It would be helpful in the future to state the experience level you are teaching to at the beginning of the video so we're not watching all the way through listening for an advanced tip that's not there. Thanks again for all you do to advance the Excel community! Best wishes in the new year.

@HULKITUP 4 жыл бұрын

Amazing! Thank you

@mirzasaj 4 жыл бұрын

Best lectures from remarkeable scholar well done im ur big fan

@Prabasmsoffice 4 жыл бұрын

Interesting tips.

@haashini10031985 4 жыл бұрын

Always likes for your teaching....

@onlytanmoy 4 жыл бұрын

Great video Leila, happy new year wishes for you 🎁

@LeilaGharani 4 жыл бұрын

Glad you like it. Happy New Year to you too!

@viswanathreddy5344 4 жыл бұрын

No words to say... about ur way of explaining... a big thnaks to you for driving us to trendy work culture...🙏🙏

@LeilaGharani 4 жыл бұрын

My pleasure. Glad you like it.

@pushpajchougule8316 4 жыл бұрын

First excel video of 2020 for me! I have been going to an Excel class here in my city. Trust me, I get to learn more from this channel than in class. Happy New year 🎉

@LeilaGharani 4 жыл бұрын

I'm glad to hear that :) Happy New Year to you too.

@shaheershujaat2223 4 жыл бұрын

Amazing video Leila well done Happy New Year 😊😊❤️❤️👍👍

@LeilaGharani 4 жыл бұрын

Glad you like it. Happy New Year to you too :)

@tahirqureshitgq7892 2 жыл бұрын

Excellent, thanks;

@sonofgodworshipper 3 жыл бұрын

perfect! just what I needed and wanted!!!

@LeilaGharani 3 жыл бұрын

Glad to help, Courtney :)

@SeemaSharma-lj3cf 4 жыл бұрын

Thank you 😊 Leila. This video is very useful for me.

@LeilaGharani 4 жыл бұрын

I'm glad to hear that Seema.

@ZAHIDHUSSAIN-ri5kg 4 жыл бұрын

Thank you Leila

@hishoegypt1980 4 жыл бұрын

THANK YOU VERY MUCH

@wayneedmondson1065 4 жыл бұрын

Thanks Leila.. Happy New Year! Looking forward to more EXCEL fun in 2020. Thanks for the printing tips. I like the keyboard shortcuts ALT, W, L (for Normal view), ALT, W, I (for Page Break Preview view), ALT, W, P (for Page Layout view) and ALT, P, S, P (for the Page Setup dialog box). Once I committed those to memory, setting up a worksheet for printing became much easier. Thank again for the tips and Thumbs up!

@LeilaGharani 4 жыл бұрын

Happy New Year to you too Wayne! Thanks for the great tips.

@sbeku 4 жыл бұрын

You are Excellent

@exceluz1014 4 жыл бұрын

Excellent video. I like it.

@johnborg5419 4 жыл бұрын

Very convenient. Thanks Leila. :) :)

@excelisfun 4 жыл бұрын

Thanks, Teammate!

@LeilaGharani 4 жыл бұрын

Thank you Mike and Happy New Year!

@samsami5923 4 жыл бұрын

Hello Leila First things first : Happy new year, hope you be stronger than ever improving exel knowledge all around the world Second, can you make a video of how to add customized page numbers(for example for the page 3 to be named page1 till the end) to specific cells(not necessary headers or footers)?

@asadreet7731 Жыл бұрын

Very nice 👍

@udayteja6595 6 ай бұрын

Thank you So much.....

@Ron502008 4 жыл бұрын

Nice job and you were really good on "The Real Rob".

@LeilaGharani 4 жыл бұрын

I wish :)

@girmabogale6376 8 ай бұрын

I love it.

@safdar1178 3 жыл бұрын

جزاک اللہ خیر، ماشاء اللہ

@sachinrv1 4 жыл бұрын

Lovely Leila; very useful. Cheers :)

@LeilaGharani 4 жыл бұрын

Thank you Sachin. Happy New Year!

@truonghoanghaminh4839 4 жыл бұрын

Cảm ơn

@fahadsaeed3175 4 жыл бұрын

Thankyou..

@michaelg-XEX 4 жыл бұрын

Good information. Readability is a challenge with large printed tables. On monochrome printers, adding Gridlines makes it easier to find the proper row/column header. On multicolor printers, formatting the data into a table with multiple colors is helpful.

@LeilaGharani 4 жыл бұрын

Great tips. Thanks Michael!

@majidsiddique8227 4 жыл бұрын

very Nice

@hosseinhosseinpoor4845 3 жыл бұрын

thanks....

@samuelkodjoe1645 4 жыл бұрын

rhat was great!!!

@hhattingh 4 жыл бұрын

Jeez! You come as if you are send. Thank you & VERY helpful

@davidroper2549 4 жыл бұрын

Leila: Yes, your video is sooo important to new users of Excel as, is ‘Format Cells’. A wonderful explanation. I hope to see you in your April 2020 visit to the UK. I hope I got the date correct ? David - Peckham, London.

@LeilaGharani 4 жыл бұрын

Absolutely correct David. See you in London :)

@crisantaylagan4118 4 жыл бұрын

Hi. Can you please make a video of VBA on repeating rows on every page except last page. Thank you.

@dkb1111 4 жыл бұрын

HaPpy New year ,Leila

@LeilaGharani 4 жыл бұрын

Thank you. Happy New Year to you too.

@ranjitmishraal 4 жыл бұрын

Thank you very much for all your tutorials. I have got many appreciations using these tip. NEED your help to make a Dynamic DASHBOARD to maintain regular KPIs. Please help me with link. Thanks and regards.

@Dragoninja 4 жыл бұрын

Page Layout is where u find Repeat columns & rows feature? I'm happy that the Header & Footer function works the same way in Word as it does in Excel.

@sulaimansait864 4 жыл бұрын

You can explain to excel sheet charting and PowerPoint

@Avijeet.1909 4 жыл бұрын

make a video on separate data like text to column with function

@marcocruz5351 3 жыл бұрын

Is there a way where you can select a specific column to be part of the print? e.g. print column A1, A3, A6 and A7 only.

@jaishrisaxena1083 4 жыл бұрын

Thanks lelia, if the header row is on 2 rows then how to write on every page in printing. Excel just allow one row not two rows Is there any way?

@shakiraasfoor7599 4 жыл бұрын

احسنتي

@NielsenEC 4 жыл бұрын

So how do I insert his formatted multi-page excel spreadsheet into a Word document?

@ravipatil117 4 жыл бұрын

Lv u

@thestitchmenagerie 4 жыл бұрын

Leila, my problem with page headers is different and I am hoping you can help. I have a multi-page report that goes across Excel horizontally. I need to get my report header to be centered on each page, but I also need it to be dynamic because it needs to update the period ending date. I tried to create a header directly at the top of the first "page" of my report, but when I use the "Rows to Repeat at top" it doesn't work from me. Is there another way to get headers to repeat on every page of a report using the Report Rows in page setup or the Header/Footer option?

@isharebyjbee2684 3 жыл бұрын

How to adjust header to print just on first page only?is there any settings?

@saeedjamshidi7000 4 жыл бұрын

Dametoon Garm! ✌

@muhammadsohail7036 4 жыл бұрын

ma,am i am sohail from lahore pakistan. i got a bundle of huge knowledge about excel by watiching your videos you udloads often about ms excel. now a days i am very much bounded on a place. when i choose a sheet to work.i select 35 cells of red color,100 cells of green color, 50 cells of pink colors and so on. this happens at once but when i want to delete these colored cell i cannot select all cells of same color for delete or no fill. this made me headache so please solve my this query and give me a chance to thanking you for prosperous and brightest futer. thanks again

@sibidi894 2 ай бұрын

I have an excel table that has about 120 rows. I want to print this table such that row 1 to 20 appears on page 1, row 21 to 39 appears on page 2 and so on. How do I achieve this?

@brianmullen2383 9 ай бұрын

I only need row 1, but it's not working for me, it's saying, "Not Valid"?

@alih555 Жыл бұрын

If i want to print specific row as fixed bottom info under a developing list

@SkyNet728 Жыл бұрын

Dear Leila, how can I change the values in multiple cell, while printing multiple copies. For example, a cover page for 20 students content 1. Name, 2. Roll Number, 3. subject and 4. semester. Thanks

@kellygrix831 2 жыл бұрын

Love your videos Leila, but I've got an issue that I can't find a solution for and was wondering if you might be able to do a video on it or just tell me how to do it... Say I have 6 rows with 52 columns (weeks in a year). Is there any way to "print" those 6 rows ALL ON 1 PAGE, with say 13 columns, then move below those 1st 6 rows that printed but still on page 1 and print 13 more columns and so on - end goal is ALL the data prints on 1 page, just 13 columns, then 13 more columns below that, then 13 more columns under that and finally the last 13 columns. Hope that makes sense and really hope you know a way to do that :) have a great day and thank you in advance !

@mattnyman9933 4 жыл бұрын

Stumbled onto something interesting. The headers to repeat do not need to be within the print range, just on the same worksheet. Not sure how I would use this, though

@LeilaGharani 4 жыл бұрын

I didn't know that. Thanks for your input.