How to Properly Print an Excel File - Printing Problems Solved!

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@nanookdan]

Not kidding, I got a promotion after spending all summer developing my excel skills with videos from Leila. If you work with data, watch her videos.

[@malithfernando7091]

Indeed ..

[@usamabashir3862]

I need help related to Excel please 🥺

[@nanookdan]

@@usamabashir3862 This is the place, what are you working on?

[@usamabashir3862]

@@nanookdan I started Job last month. My starting work is in Excel..

[@lucutes2936]

what's the hardest skill you've learnt about Excel?

[@vipuljindal4584]

REALLY HELPFUL AND QUICK WAY OF PRINTING: Select area to be printed Press Alt P R S (set print area) Now press Ctrl+F2 (print preview) Print!

[@Rajiv2891]

This channel has been a boon for people working in spreadsheets on daily basis to improve their skills and reduce a hell lot of time. So much informative each and every video is. Thanks for sharing such informative knowledge!

[@JimFikes]

Another great tutorial, Leila. I have never felt that watching your training materials were a waste of my time. For as many years as I've been teaching and using Excel, you always teach me something new.

[@LeilaGharani]

I'm glad to hear that Jim. It's great that I can still surprise you :)

[@lastidiastore]

@@LeilaGharani I hope you make a video on how to print a small table to fit a whole page. sometimes when I do print preview, the table looks fine, but when I print it it looks smaller even though I set the page to A4

[@mezianeremila454]

It is frustrating to watch Leila's excel video without having learned anything new, it has taken me years to learn all these things and you summerized it in 10 minutes, that's the genius about you by the way...

[@LeilaGharani]

Sorry you didn't find anything new this time.

[@scarlettnguyen9627]

OMG I wish I knew you sooner. You are my life saver!! Please release more episodes for us to follow !!

[@LeilaGharani]

Will do 😊

[@pushpajchougule8316]

Did face the printing problem last week, I was able to get it printed with some adjustments but didn't know there's more to it. Thanks again. You actually know what practical problems one could have while using excel. Experience speaks! 😊👏

[@LeilaGharani]

Oh yeah! I wasted my fair share of paper in the past :)

[@SNAPPSociety11]

I've watched other tutorials on KZbin and didn't learn anything. Watched yours and GOT IT. Great explanation, THANK YOU!

[@LeilaGharani]

Happy to hear that!

[@sunilg9667]

I highly recommend this channel for the one who really want to improve their excel skills..

[@naqshgarg7625]

I was talking to one of my friend that you may work on many fancy BI tools but excel is and will remain misterious as everyday we learn new things out of it. Thanks To Leila Gharani unlocking this for us. Many thanks👍

[@LeilaGharani]

You're very welcome. I'm also unlocking new things all the time with Excel :)

[@shashaip3977]

I enjoy her explain step by step and have subtitles

[@thinkdunson]

5:35 don't forget that it's going to include the entire cell even if it only contains a tiny bit of spill-over. so make sure your last cells on the bottom and right are tight to, in this case, the graph. also, if you're printing only text and you want it to be centered correctly, you need to have the cell's text alignment also set as centered vertically and horizontally. because excel is only trying to center the cell itself when you print.

[@darrylmorgan]

The Complete Excel Essentials Course is full of Awesome Tips and Tricks like this!Thank You Leila

[@LeilaGharani]

I'm happy to hear that Darryl. Thanks for the kind feedback.

[@lejomdavid8538]

great video... an additional useful tip is the shortcut 'Ctrl + F2' for a quick print preview.

[@wmfield152]

This is one of the most helpful Excel videos. Before watching I was not familiar with all the printing options that are available. Thanks again L!

[@LeilaGharani]

You're very welcome!

[@riverjig]

Thanks for this. I couldn't figure out how to get my document centered. You showed me that there is a horizontal center option in margins, which I missed, and it fixed it.

[@umeshchittirai]

This really solved my problem which has been going on since long time. Thank you for the video

[@anilkumarnvs8121]

You made me fell confident and independently handle my worksheet. thank you for the Amazing content

[@LeilaGharani]

You're so welcome!

[@rasoulkhoshravan5912]

I know almost all these tips except for page breaks. It is a good way to adjust the page breaks.

[@ohgasauraus]

Thanks! This fixed my problem of windows scaling that affect how a properly formatted excel misaligned when windows scaling no longer 100% on other PC! By using Print Area and Scale to Fit Width & Height to fix the issue.

[@ChaosOrZen]

As always, you're the best!!

[@akperfumes]

Leila your tutorials are always on point. Thank You😎

[@AmitChauhan007]

Thanks a lot, Leila, your videos are really helpful, crisp, and clear.

[@LeilaGharani]

Glad you like them!

[@springinfialta106]

These are all great ideas when you can adjust each report on a case-by-case basis. I had to create an Excel macro to automatically generate reports with data sets and tables that would vary in size. When I tried to automate the formatting and page breaks in Excel it was a nightmare. Also, when different people ran it from different computers hooked to different printers the workbook got corrupted and became very slow to load and run. I think this had to do with having it adjust to different printers. I instead offloaded the formatting to an MS Word macro. That was a still a nightmare, especially with making sure the tables broke across pages in a neat and logical way, but at least my Excel workbook no longer got corrupted and poor performing.

[@Ashish__Sahu]

I found this video very helpful, it has solved a lot of things , Thank You

[@josephcoon5809]

Thanks for another excellent video!! 1. I changed my settings to default to View > Page Layout so I’m always formatting my sheets for printing. 2. I think that it is worth noting that if you print to multiple devices, the print area may be different. Printers have slightly different printable areas and OneNote (I send sheets to OneNote on occasion) is usually quite a bit different than a standard printer. It is good to be mindful of the output your Excel Workbook is set to.

[@LeilaGharani]

Thanks for sharing your tips, Joseph!

[@JoaquimParis]

Love your channel, love your work! Recommended to most of my colleagues.

[@LeilaGharani]

Thank you very much!

[@mariostudio7]

Always think before you print people! 🌲🌳 Awesome video! 😊

[@LeilaGharani]

Very true. Glad you like the video!

[@qismatali4073]

You explain in supper easy way that what i like so much. Thank you Laila.

[@LeilaGharani]

Happy to hear that!

[@saadsayyed1536]

I was not able to print gridlines and that's the reason I randomly searched on google and found this useful video. Thanks a lot

[@1877Pegasus]

Leila, I'm a fan of your! On top of your great explanation, I would point out that if you drag the page breaks in order to fit more content (as you did with the two graphics in the second page) it would zoom out the content. So if you do that vertically, it also shrink horizontally and will no longer cover the width of the page.

[@LeilaGharani]

True - we have to make sure the end result isn't too small on the printed page. Thanks for your comment :)

[@NewbieInForeignLand]

Wow !! What would I have done without you!! Thank you so much for such amazing videos

[@aljunjumagdao6286]

I like your voice Ma'am, really interesting to watch and effective.

[@georgeslehner7733]

Leila, I do like the way you present your video. I do learn a lot of tricks from your videos and want to thank you! I have a little challenge that I can't figure out. I need to print, it's a single separate sheet, the copy number from a variable (or a cell value). Copy 1 of 25, copy 2 of 25 and so on. Sorry for my english, I'm a french canadian from Montreal in Quebec, Canada. Hope you can help me! (By the way my late father was born in Linz, Austria)😉

[@leosmilesu2]

You make learning new things fun and easy with your awesome styles of teaching and presentation. Thank you again

[@LeilaGharani]

Thank you for the kind feedback Leonard.

[@Betterifitsfree]

Glad to see that you are addressing my novice problems. Thank you once again.

[@LeilaGharani]

Glad to help. Hope it will come in handy.

[@Betterifitsfree]

@@LeilaGharani More than you know.

[@ananguyen4509]

Thanks Ms Leila for another great video.

[@signalmas5673]

This is one of the situations when really no one appreciates that you made the effort to optimize report printing, yet if you don’t there will be rolling eyes. I use the Set Print Area to set non continuous ranges to print, each range selection is automatically it’s own page. I find this easier to control than ‘moody’ page breaks. To do so after your initial selection of the range, select the additional range, Page Layout>Print Area>Add to Print Area

[@LeilaGharani]

So true :) Thanks for your input.

[@thinktoomuchb4028]

Very helpful! But do you have a video on resolving the problem of shapes being distorted when printing, e.g. circles printing as ovals?

[@katerina6495]

Wirklich fantastisch Leila, diese Drucktricks sind sehr nützlich Viele liebe Grüße 🌞

[@LeilaGharani]

Freut mich Katerina :)

[@kadavisweswararao7982]

THANK YOU VERY MUCH MADAM. I LEARNED NEW THINGS FROM YOUR VIDEO.

[@LeilaGharani]

Glad to hear that.

[@Deependra1991]

Why didn't you made this video years back. Anyway now is better. Thanks for sharing such a wonderful steps of print setup as always you do....

[@LeilaGharani]

My pleasure. I hope it will be helpful.

[@divyamsaran]

Excellent and a highly helpful video. Much useful than my college lectures.

[@LeilaGharani]

Glad it was helpful!

[@edmunfania6043]

You save my life with my Boss Today thank you

[@joseapar]

I'm surprised you didn't touch on the page layout view. If i'm printing i find it much easier to be in that view and make the adjustments there to how things will look when i print them. You can make many of the adjustments from that view and you get a direct page view of how things will print without having to go back and forth between the sheet and the print preview screen.

[@1877Pegasus]

You are so right

[@LeilaGharani]

True - that's a good one. We cover that inside the course when we talk about adding headers and footers and I think in the follow up video we have on repeating table header coming out in 2 weeks as well....

[@habibsicttutorials6684]

You made it sound so simple and easy! Thanks

[@LeilaGharani]

You're welcome!

[@TheGamecheater100]

thank you so much, that page break preview thing was what i was lookin for

[@LeilaGharani]

Glad I could help!

[@ronvds4713]

These a the basics that you should know when starting out with excel. Good to see that you don't ignore these points.

[@LeilaGharani]

Never forget the basics :)

[@johnq3543]

Another great video, thanks Leila !!

[@LeilaGharani]

My pleasure, John!

[@ozmaorigrl]

Thanks .... sorted my work stuff out today!

[@LeilaGharani]

Glad it helped!

[@Me_ThatsWho]

Thank you. The substance starts at: 2:57

[@stefwata3461]

SET PRINT AREA DID IT!!!!!! YOU R AWESOME!!!

[@mattschoular8844]

Thanks Leila...Happy Holidays to you and your family...

[@LeilaGharani]

Thanks Matt. Same to you and your loved ones.

[@yulinliu850]

Very helpful tips. Thanks Leila!

[@LeilaGharani]

My pleasure. Hope it will come in handy.

[@edwardkhatiya4561]

My crush! can't believe this! Every point sinks in!

[@nindajuka8427]

Very helpful tips! Would you make video about putting color in excel? I mean, in table header and its values. What we should do and dont when mix match color to make it more comfy to read

[@raoahmed4139]

Hi, Its good question, i could solve it if you wana to auto change color or row cell etc

[@theManagementLab]

Thanks Leila! You are a saviour.

[@nipunkavinda8254]

Very useful video specially for the finance people work in companies...

[@krn14242]

Thanks Leila. Great video as usual.

[@LeilaGharani]

Thank you for your comment and dropping by.

[@ismailismaili0071]

That was epic I have never known these info to be honest thank u so so much Ms. Leila

[@LeilaGharani]

I'm glad you discovered something new Ismail :)

[@bhagwatimaurya1827]

Your videos are really great, helpful. I needed this one. Thanks a lot

[@pollinatorkioplop5790]

Thanks you for your help! You're always useful

[@jasonagresti3069]

You are a great source of inspiration. Thank you very much. In Honor! Jason

[@madhupolineni8279]

your video's are Great easy to understand

[@shabbirkanchwala-abwaab6263]

Really very very useful printing Tips. I wasted papers several times. Thnx

[@LeilaGharani]

Same here but no more :)

[@simoiyahector-morales3781]

Excellent trick, thanks for sharing your exceptional knowledge of excel.

[@LeilaGharani]

My pleasure Simoiya. Hope it will come in handy.

[@abdiqanimahdi2331]

Thanks a lot. You made me laugh how you explain it, and again give me useful tips 😅 .. "i was confused adjusting page margins all the time "

[@markzalavari1780]

Hey, I was expecting the other important feature: how to put the fixed headings onto all of the pages: PAGE LAYOUT > Printing addresses > top sequent lines > full of more options!

[@LeilaGharani]

That's the topic of the next video on printing coming in 2 weeks :)

[@thetourminator]

I totally LOL'd at that 0:56 "wasting trees" video insert.....NICE. :)

[@LeilaGharani]

😁

[@darkshinigami9438]

I'm eagerly waiting for the next videos in the accounting series :)

[@LeilaGharani]

They are in the works. We will restart next year :)

[@darkshinigami9438]

@@LeilaGharani Amazing, I can't wait for the LIFO FIFO video and much more others :D

[@myrsinireid9089]

Love this! Perfect 👍🏻

[@sunilgagat2881]

Amazing well explained clear my concept from INDIA

[@gordonodhiambo1128]

Phew! I love this & I LOVE YOU

[@NikunjDM]

My big problem solved, Thanks my best teacher

[@LeilaGharani]

Happy to help!

[@girmabogale6376]

I love your tutors

[@richardhay645]

Great summary.

[@wahidovich2021]

God bless you Leila, thank you very much!

[@tomjun8945]

Thank you for the amazing training !!

[@LeilaGharani]

Glad you liked it!

[@TejasCandade1978]

Amazing, i learnt something new from you.

[@radhikamishra2130]

Hi Leila , i learned a lot from you. I have a doubt , how to increase font size of specific area in excel print. For example in your sheet how to increase font size of first table without change second table.

[@Luciano_mp]

Greats tips. Thank you Leila.

[@khantravelguide]

Addicted to your vids xxx

[@ejazminhass614]

Very useful tips

[@InsideMyWall]

Having problem in a sheet having free forms drawn in separate cells. The free forms seems to jump from its place while selecting print preview. Please make a video on that. Also lessons on how to adjust page breaks while printing sheets will be helpful.

[@darrengodkin]

Brill tips! Must insist that my boss watches this video at least 4 times 😀

[@LeilaGharani]

Haha. Better not disappoint him then :)

[@MsFlaca5]

Thank you for this video I just have a question I’m trying to print my worksheet out but how do I get rid of the letters on top and the numbers on the side??

[@AbdulRahman-lv6sy]

Hi Amazin am a great admirer of your videos which gives immnese help in managing basic functions in excel. Can you make a video on time excel chartsThanks

[@GautamSangwan1]

Thanks for the knowledge session.

[@wayneedmondson1065]

Thanks Leila!

[@Rufus-OG]

Hi Leela, I am loving the channel and have found a lot of your advice very useful. Unfortunately in this case Microsoft has once again left the Excel for Mac users hanging. On the Mac we don't get print preview or the option to go to Page Setup from the Print option in the file menu. I have only recently had to move to a Mac (a long time PC user) and Microsoft have done a nice job of missing out some important Excel functions in the Mac version - for no reason as far as I can tell. Not available on Mac - Forms, Xlookup - Print Preview etc. I'll keep enjoying your channel anyway and hope that one day Microsoft will give us Mac users (paying our full price yearly subscription) the full windows version of Excel

[@LeilaGharani]

That's too bad. Not sure why these features are different. Maybe some day ...

[@1877Pegasus]

I'm sorry man. Mac may be great for many things but when it comes to MS Excel it is always a few steps behind

[@ExcelExciting]

Thanks for sharing... !! Great Tip

[@LeilaGharani]

You're welcome Faraz :)

[@MrSupernova111]

Hi Leila, this was a good overview of the Excel print features. Question: I'm rebuilding a complicated Excel file at work to automate some of the functions. This file is a multi tab file so rebuilding it was the best option. Whoever made the original file was able to create dynamic "print areas" meaning that the page auto adjust the print area depending on the number of rows with data. Can you make a video showing how this is done or point me in the right direction? Thanks!

[@LeilaGharani]

Good idea. I'll add it to my list for future videos. Thanks for the suggestion!

[@aliibrahim1235-c6i]

thank you from Egypte 🌹🌹

[@muhammadsohailashraf6059]

Madam you are great teacher for all of us. I am learning a lot of information from you. I have a question about printing ... I have a data in Column A only . but it is more then 10000 rows.. I want to print it all but when i print. it will come one colum only and balance 80% page will be empty. I want when its print like zigzap but in vertically. like column, i can say when it print on page it should come like colum wise.. i hope you understand my means. if you give me i can send you a small diagrame. it is will be easy for you to understand. TIA

[@rameshlama574]

really eye opener , simple things makes big difference. Thank you for the video.

[@andrewlowden322]

I JUST taught these tips to a guy in my office 2 days ago! He had a chuckle watching this w me. question though: with the sheet you had it would have looked better w the 1st page in portrait and 2nd landscape; is it possible to determine orientation page by page?

[@LeilaGharani]

Glad you guys liked the video :) Regarding your question, page orientation is a worksheet property. Meaning all pages printed from the same worksheet will have the same orientation.

[@sulaimansait864]

You are explain very super mam so more update video tell about outlooks

[@shanesmohammed]

Marvelous LG!!

[@romeltborja]

Thank you Leila