How to Print Excel Sheet

In this step-by-step tutorial, learn how use Excel page setup and print. We cover how to print to one page, how to print your Excel sheet in A4 size full page, how to include table lines / gridlines, and more. By the end of this video, you'll know how to customize how your Excel sheet prints.

👋 Additional resources

⌚ Timestamps
0:00 Introduction
0:35 Load print dialog and preview
1:39 Visualize page breaks
2:11 Print selection
2:58 Set print area
3:34 Hide column from printing
4:20 Portrait and landscape orientation
4:43 Page type including A4
4:53 Margins
5:03 Scaling
5:36 Repeat headers on all pages
6:23 Add headers and footers
7:41 Add table lines or grid lines
8:21 Additional options
9:14 Page break preview
10:56 Wrap up

📃 Watch related playlists

🚩 Connect with me on social

🙏 Request How To Tutorial Videos

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#stratvert #microsoftambassador

[dantecamargo]

Printing a simple document in Excel is a nightmare! Microsoft should do something to make life easier for us users.
Thank God we have this video. Thank you Kevin.

[johnakidd]

This is one of those videos I wish I could have watched a long time ago. It would have saved me a lot of time looking these techniques up.

[njokuochafrancis]

You are more than a teacher sir!.
Not thanking you is just same as saying don't watch your videos, you deserve more than a "Thank you" sir.

[Hopefully]

Hi Kevin, I print things from Excel all the time so I assumed I wouldn't learn anything but I actually learned a few very useful things, so thanks so much for that. Thanks again for always putting out stellar content!

[arashy]

Solid help for beginners (and those of us who haven’t printed in years)!

[jingzhang]

I was looking for paper break skills for a long time! This tip really helps save me a ton of time!

[dickschwanke]

Including the grid lines definitely helps making the sheet more readable for the end user. I also like shading some rows but clicking on the row number then home/format/format cells/fill and giving it a light shade of gray. This effect looks like tables in Word, with the added option that one can shade something other than every other row. Doing this for a couple page printout is often worth the effort, especially if the Excel sheet is inserted in a longer document going to press.

[anagomez]

Kevin !!! You are helping an old lady here, I thought I understood your directions, I guess I didn’t, I could not fix the situation, but I didn’t give up, and I did something and at the end I fix it!!! It was your gentle, fun and motivation way of teaching, that allowed me to persevere and I did it . I am a new subscriber, thank you for empowering me 💪🕊😀

[selvappriyaabhavaanee]

Thank You very much, Dear Mr. Kevin Stratvert!
In fact not many are so fluent with printing their tabulation jobs done thru Excel.
Me too!
That is until I grabbed hold of the hidden intricacies in Excel!
Your informative article video instructed me on more unknown nuances and intricacies.
Mastering MS Excel is indeed too a gigantic task!
And mastering MS Office wholly is even more gigantically gigantic!
Thank you very much once again!

Years ago, on my very first day, as the instructor of Computer Applications, before the students, I filled up columns upon columns and created a table. (Of course, carefully evading visits to the unknown corners in it!)
Formatted painstakingly every data in each cell and "Presto!"
"Control + P" and a stylish gesture and a "Hit "on the "Enter Key!"
- - - -
The single table of a quarter of a page gobbled up the full ream of paper and blinked for more!
I forgot to "Set Print Area!"

[graceyim]

It's so much harder than it looks. Thank you for a good video, Kevin.

[johnnymaebradford]

I just started watching your videos recently but find them very helpful. Only thing, I am a senior & you go a little fast for me 😀😀

[NirwanJGrg]

I can't express how grateful i am for this vid. Really helped me last minute with my college assignment. Thank you so much.

[joukenienhuis]

Thank you for these tips. I knew a lot to format a page for printing, but this is way easier. I specially love the page layout button down below and the resetting of the page breaks

[IrfanNasir]

Thank you very much for this comprehensive video on excel.

[i.a.o.]

Kevin! Aren't you getting some advising on how to catch the viewer's attention? You are soooo gooood! Good luck & God bless! I recommend your channel to all! Always!

[ashokp]

Good video.
Awaiting next video on printing, covering other features in Page Setup menu.

"Scaling" in Page sub-menu to print text in large font without actually changing font size in the sheet.

"Black and White" and "Copy count" in
Print sub-menu in Sheet

Page set up and printing of a Workbook with different ranges of data with differently formatted and or similarly formatted Worksheets.

[zakylib]

I feel like this topic is not something I need. Quite basic. But Kevin always has a tip that makes you go, "I did not know that!"
Thanks for all you do.👌

[a.z]

I've gotta rewatch this video a few times to get it 😖 I absolutely LOATHE Excel! Thanks for helping us Excel dummies....

[mariannebrokaw]

Thank you! Exactly what I needed and so simple!

[howardj]

Outstanding presentation. Thank you Kevin!