How to Print Excel Sheet

Рет қаралды 380,231

Күн бұрын

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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
- Sample workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whN9eP...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ 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
- Playlist with all my videos on Microsoft Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🙏 Request How To Tutorial Videos
forms.gle/BDrTNUoxheEoMLGt5
🔔 Subscribe to my KZfaq channel
kzfaq.info?...
🎬 Want to watch again? Navigate back to my KZfaq channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ 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

Пікірлер: 184

@KevinStratvert 2 жыл бұрын

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@dantecamargo 2 жыл бұрын

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.

@jenguerro7880 11 ай бұрын

agreed!

@johnakidd 2 жыл бұрын

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.

@jcsmith3806 Жыл бұрын

Excel is extremely user unfriendly...

@isaacmightyemmanuel288 2 ай бұрын

Extremely!

@dianeday1297 Ай бұрын

Amen...

@Hopefully2025 2 жыл бұрын

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!

@selvappriyaabhavaanee117 2 жыл бұрын

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!" Whirrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr - - whirrrrrrrrrrrrrrrrrrrr - - whirrrrrrrrrrrrrrr!! 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!"

@arashy 2 жыл бұрын

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

@anagomez9620 2 жыл бұрын

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 💪🕊😀

@joukenienhuis6888 10 ай бұрын

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

@dickschwanke300 2 жыл бұрын

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.

@graceyim2941 2 жыл бұрын

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

@njokuochafrancis3688 Ай бұрын

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.

@howardj2878 2 жыл бұрын

Outstanding presentation. Thank you Kevin!

@gajabathiarjuntg2390 2 жыл бұрын

Great video Kevin. Thanks for pulling out this video.🤗

@walkerblizzard 2 жыл бұрын

Thank you trees for allowing Kev to make another great video!

@mariannebrokaw4525 4 күн бұрын

Thank you! Exactly what I needed and so simple!

@NirwanJGrg 3 ай бұрын

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

@sassone5106 2 жыл бұрын

Bravo Kevin!!! 👋 Thank you 💓. Useful

@jingzhang5372 2 жыл бұрын

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

@KevinStratvert 2 жыл бұрын

👍

@DanielDuedu 2 жыл бұрын

I don't miss your videos, there is always something to learn.

@vi_EviL_iv Жыл бұрын

Thanks for the video, good refresher! Straight to the points! Awesome

@rajanrana4887 2 жыл бұрын

Best awaited series from you Thanks man

@IrfanNasir 3 күн бұрын

Thank you very much for this comprehensive video on excel.

@brenthair1228 2 жыл бұрын

So packed with useful tips that I need to watch it again and save it for future refreshers - thank you!

@Gelovan682 2 жыл бұрын

yes, about 50 tips to get to a readable spreadsheet. How wonderful.

@jsiva8577 3 ай бұрын

Excellent, and thanks for your great support.

@fazlaykhan 9 ай бұрын

I am from Computer Science and Excel is totally new to me, Just watched this video now everything is clear to me! Thanks man!

@PeterJavea 10 ай бұрын

Thanks. Helped right away

@danielgaray500 Жыл бұрын

Thank you Kevin, you just saved my thesis!

@SECYBERSAFE 2 жыл бұрын

Best video on this topic

@talitaeugene9148 Жыл бұрын

Amazing tutorials!!!!so easy to follow thru

@zakylib 2 жыл бұрын

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.👌

@Albert00310 2 жыл бұрын

Nice and very complete tutorial!!

@roberte.bainesjr.7164 8 ай бұрын

Wow ... this was soooo helpful. Thank you.

@dastaan. 2 жыл бұрын

Always informative 👍🏻

@a.z777 5 ай бұрын

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

@MrDo2an 5 ай бұрын

Very professional and useful, thank you!

@canirmalchoudhary8173 2 жыл бұрын

Blown away, I never knew the inserting page break 😳. Even some time ago I struggled but today I am hilarious 😂

@pattyh23 10 ай бұрын

super helpful ! thank you very much!

@i.a.o.2909 2 жыл бұрын

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!

@azizagamirzeyev1143 Жыл бұрын

Thanks a lot man, this print tricks are really helpful 👍🏻

@prokorshopal4865 2 жыл бұрын

0:00 - Hi Kevin. 👋 11:31 - Definitely 631st thumbs up from me to the majestic video. 👍 Cheers.

@nathanpickford2207 Жыл бұрын

Thanks so much bro, this was a huge help!

@rosachinchilla13 Жыл бұрын

Lovely. Thank you!

@ashokp4536 2 жыл бұрын

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.

@mrhusin6300 2 жыл бұрын

Thanks Kevin...simple but awesome

@KevinStratvert 2 жыл бұрын

You bet!

@menosthao1899 Жыл бұрын

Thank you and thanks for the trees as well so much!!!

@jsiva8577 3 ай бұрын

Thank you so much

@shanbiepop7989 3 күн бұрын

Helpful thanks

@lukeelliott2128 2 жыл бұрын

This is helpful, thank you!

@KevinStratvert 2 жыл бұрын

Glad it was helpful!

@brendamartinezgomez2297 Жыл бұрын

Thanks for the video

@soulrejuvenation6204 2 жыл бұрын

very clear and concise

@rainbodigon6965 5 ай бұрын

thank u it really helped!!!

@sedarathnadcd 2 жыл бұрын

Thank you Kevin, You saved lots of my sheets with this video.

@3dgarmentexperts258 2 жыл бұрын

Many thanks for sharing..

@Aamiranalyst Жыл бұрын

Extraordinary one of best teaching techniques

@kelvinmwangangi9320 11 ай бұрын

This is so informative. Thanks Alot

@syedmdimdad9422 2 жыл бұрын

🎊Love you from India👌

@blueashcroft Жыл бұрын

As an accounting student, this helped me a LOT.

@shanudaniel07 10 ай бұрын

Thanks Kevin your vedio was very helpful 😊

@c.lalrinchhana7364 Жыл бұрын

Thank you for this video, it help me a lot

@salmaalaa7860 2 жыл бұрын

very interesting thank you kevin

@abduljabbar8124 2 жыл бұрын

You are really great man...salute to you

@johnnymaebradford3400 2 жыл бұрын

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 😀😀

@KevinStratvert 2 жыл бұрын

Thanks for the feedback! Will adjust.

@texasseastar 2 жыл бұрын

Pro Tip: Create a folder in your KZfaq account under the SAVE header just for Kevin's video's (or maybe call it a Cookie Jar) You can then bookmark them and refer back to them later using play/pause/play/repeat until you're confident you understand the instructions. I have multiple folders on the various topics I'm interested in and that way I don't have to do a search to find the videos again.

@ricardoluizmarcello 2 жыл бұрын

I love your videos because I learn about computing and English at the same time

@KevinStratvert 2 жыл бұрын

Rachel's English (channel on KZfaq) is awesome for English. Well worth checking out.

@ricardoluizmarcello 2 жыл бұрын

@@KevinStratvert thanks!!

@luisburgos5500 11 ай бұрын

Thank you very much you save my day at work.

@user-co6xl8sd4k Жыл бұрын

Thanks to the trees and you :)

@jemimahnweke3928 10 ай бұрын

This is very helpful. Thanks for sharing

@abdikhaliqmohamoud3373 2 жыл бұрын

I thaught I am good at Excel, but kevin makes things better and bigger than always.

@ZarrinTasnimshakuntola 2 жыл бұрын

I won't say thank you Kevin. Rather I'd say loved this amazing vedio a lot. Keep it up! :)

@tanjinsarker1562 2 жыл бұрын

love every one of your video

@certainty101 2 ай бұрын

This video just save my job within just about 12mins I got what I wanted.

@eddiemarch4214 Ай бұрын

Dude thank you so much!! You rocked it in a 5 minute simple and easy to understand instructional video. I hate Excel. I rarely ever have to use it. I wanted to make a new chart today to print out and thought the biggest problem would be printing it in a way that fits correctly. Thank you!! And yes thank the trees I love the trees, we hang out frequently, I talk And they listen. Then I shut up and I listen. 😂

@Kanuya4617 5 ай бұрын

Helpful and On the point guide very nice👍

@hasanmohammadtareq89 4 ай бұрын

Splendid. ❤

@JustBlankNoInfo 2 жыл бұрын

Printing in Excel? Wow!

@ZiEmpire Жыл бұрын

I love trees but i need my sheets to be printed out 🤩 Let's start planting then to have abundant use in the future ♥️

@mehmetdogu384 4 ай бұрын

good Kevin.

@lionels839 2 жыл бұрын

Best excel guy. Dot.

@nihayatsabah2166 2 жыл бұрын

Thanks 🌹 😍

@XLLearner_Courses 8 ай бұрын

Great video

@shastaham7630 2 жыл бұрын

White Chocolate Macadamia Nut column: Narrow the column and let the title flow to two lines (set that row height to fit). That will cause the print area to enlarge to fit the narrowed column(s), and coincidentally push more rows to page two. Also, page numbers are traditionally placed in the bottom header.

@RickTexas 2 жыл бұрын

I was going to suggest the same thing about the White Chocolate Macadamia Nut column. That is a waste of space that would make the page easier to read if fixed.

@KevinStratvert 2 жыл бұрын

Ah, missed that! Good call out 👍😅

@gustavopineda7933 Жыл бұрын

100% Quality

@bmo3778 2 жыл бұрын

right after the funny skit, I was reminded how "printing excel sheet" is a serious matter between a promotion or demotion back to archive room

@KevinStratvert 2 жыл бұрын

😅

@nofakesallowed6377 4 ай бұрын

😅😅😅BECAUSE OF THE CRAZEEE SOUNDING BEAT AT THE END I JUST SUBSCRIBED😅😅😅😅

@vinlandviking 5 ай бұрын

Groot thanks you.

@wesunese5802 2 жыл бұрын

helpfull video! I would like u to make a video of printing cad drawing A4 and A3 paper.

@_darsh 2 жыл бұрын

Starting part was funny😅 (when you go to File then Print)

@surasakpootinun8799 2 жыл бұрын

Hi Kavin Thank You so much. I never get it right when I print the tablein Exel. Cheers

@kwakuneutral438 2 жыл бұрын

Thanks trees 😁

@Farhanawan443 2 жыл бұрын

This video really help full. If my small amount of data going to next page then want increase the font size and width of rows. To making read easy. But this not works fine. Suggest to how i do this.thanks

@eleenawest1931 2 жыл бұрын

I'm a silent subscriber but today I have a question. I made a duty roster on landscape orientation that spilled to a second page as there are more & larger columns than rows so I chose to fit the sheet in one page. However, I now have a new problem. Although the sheet is evenly placed from side to side as the margin allows, it is not evenly placed from top to bottom on the A4 size so the content is in the middle with too much blank space at the top and bottom. Please, how do I spread the content evenly across the page? Great job Kevin. I must commend you. Your explanations are always very clear and easy to understand. You have no idea how much you have helped me with your videos. More power to your elbows. Thank you!

@ValorantRivals 2 жыл бұрын

God bless those trees

@brichter4669 2 жыл бұрын

At work, I am known as the formatting guru. I used to have a strict boss who said no one is to ever send an unformatted document or spreadsheet to a customer or vendor. My biggest pet peeve is when someone sends a spreadsheet and selected border formatting across the entire spreadsheet, and it will print a lot of pages. So, I got used to reviewing print/formatting every document/spreadsheet. I would have lessened the width of the white chocolate column by wrapping the text and using ALT+Enter to drop text to another line within the cell, then narrow the column. When there are a lot of columns, landscape orientation will be needed. I sometimes use page setup, page, Fit To and add a number of pages. Then I go back to print preview and see how the page(s) looks. If there are multiple pages, I use the header/footer tab, go to the footer section, click on the drop down arrow and chose Page 1 of ?. This lets people know how many pages are in the worksheet. Sometimes spreadsheet formatting can be a challenge, but I enjoy it.