How to Properly Print an Excel File - Printing Problems Solved!
Vložit
- čas přidán 17. 07. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
When you share an Excel file with others, you never know who’d like to print it. There might be times, you intentionally format your Excel sheets for printing - for example when creating handouts for your presentation.
There might be times you create Excel files that you don’t intend to be printed but if you’re sharing files with others, specially your boss, make sure you format it for printing. You never know who prefers a printed version and you’ll get extra points from your boss if you make their lives easier.
🔑 Key Takeaways:
- Discover effective strategies to optimize Excel sheets for printing.
- Learn to manipulate print settings for professional-looking reports.
- Gain insights into Excel's printing nuances to prevent common errors.
🎥 In This Tutorial:
- Print Preview Essentials: Navigate to print preview for an initial assessment of your report layout.
- Fit to Page: Learn techniques to fit your data neatly onto a single page.
- Page Layout Adjustments: Explore options to align, scale, and organize your data before printing.
- Managing Margins and Orientation: Customize margins and choose between portrait or landscape orientations for optimal space utilization.
- Scaling and Gridlines: Understand how to adjust the scaling of your sheet and decide whether to include gridlines.
- Centering Reports: Center your data both horizontally and vertically for a balanced appearance.
- Setting Print Areas: Define specific areas of your spreadsheet for printing, focusing only on the necessary data.
- Inserting Page Breaks: Gain full control over where your pages break, ensuring charts and tables are printed completely and coherently.
🌟 Why Watch This Video:
- Ideal for professionals who frequently present Excel reports in meetings.
- Crucial for anyone looking to save time and resources by avoiding repeated printouts.
- Perfect for those aiming to create a positive impression with well-organized, readable reports.
00:00 Solve Excel Printing Problems
02:00 How to print an Excel sheet
02:30 How to fit an Excel sheet to be printed on one page
03:25 Excel Printing Options on Page Layout tab
03:46 How to center selection on printed page in Excel
04:24 Print Excel spreadsheet with grid lines
04:34 Adjusting scale for printed sheet in case printed Excel sheet is too small
05:55 Printing selected areas on Excel sheet
06:33 Setting Excel print area to print specific areas
07:25 Clear print area
07:30 Add page break to Excel sheets
⯆ Blog post on Excel Printing tips and tricks: www.xelplus.com/excel-printin...
Excel Basics Complete Tutorial list: • Unleash your inner Fin...
➡️ 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
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
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.
Indeed ..
I need help related to Excel please 🥺
@@usamabashir3862 This is the place, what are you working on?
@@nanookdan I started Job last month. My starting work is in Excel..
what's the hardest skill you've learnt about Excel?
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!
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.
I'm glad to hear that Jim. It's great that I can still surprise you :)
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!
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! 😊👏
Oh yeah! I wasted my fair share of paper in the past :)
Leila your tutorials are always on point. Thank You😎
Your videos are really great, helpful.
I needed this one.
Thanks a lot
Wow !! What would I have done without you!! Thank you so much for such amazing videos
OMG I wish I knew you sooner. You are my life saver!! Please release more episodes for us to follow !!
Will do 😊
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!
You're very welcome!
I've watched other tutorials on CZcams and didn't learn anything. Watched yours and GOT IT. Great explanation, THANK YOU!
Happy to hear that!
As always, you're the best!!
You are a great source of inspiration.
Thank you very much.
In Honor!
Jason
Thanks a lot, Leila, your videos are really helpful, crisp, and clear.
Glad you like them!
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...
Sorry you didn't find anything new this time.
You made me fell confident and independently handle my worksheet. thank you for the Amazing content
You're so welcome!
You make learning new things fun and easy with your awesome styles of teaching and presentation.
Thank you again
Thank you for the kind feedback Leonard.
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.
great video... an additional useful tip is the shortcut 'Ctrl + F2' for a quick print preview.
This really solved my problem which has been going on since long time.
Thank you for the video
Thanks you for your help! You're always useful
That was epic I have never known these info to be honest thank u so so much Ms. Leila
I'm glad you discovered something new Ismail :)
I enjoy her explain step by step and have subtitles
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👍
You're very welcome. I'm also unlocking new things all the time with Excel :)
I found this video very helpful, it has solved a lot of things , Thank You
God bless you Leila, thank you very much!
Thanks Ms Leila for another great video.
thank you so much, that page break preview thing was what i was lookin for
Glad I could help!
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.
Thanks Leila! You are a saviour.
Love your channel, love your work! Recommended to most of my colleagues.
Thank you very much!
The Complete Excel Essentials Course is full of Awesome Tips and Tricks like this!Thank You Leila
I'm happy to hear that Darryl. Thanks for the kind feedback.
I highly recommend this channel for the one who really want to improve their excel skills..
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.
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.
Thanks for sharing your tips, Joseph!
Thanks for the knowledge session.
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.
Very helpful! But do you have a video on resolving the problem of shapes being distorted when printing, e.g. circles printing as ovals?
Greats tips. Thank you Leila.
I know almost all these tips except for page breaks. It is a good way to adjust the page breaks.
Very useful video specially for the finance people work in companies...
You made it sound so simple and easy! Thanks
You're welcome!
Amazing, i learnt something new from you.
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
Love this! Perfect 👍🏻
Thanks Leila...Happy Holidays to you and your family...
Thanks Matt. Same to you and your loved ones.
You explain in supper easy way that what i like so much.
Thank you Laila.
Happy to hear that!
Thanks .... sorted my work stuff out today!
Glad it helped!
Phew! I love this &
I LOVE YOU
Addicted to your vids xxx
Very helpful tips. Thanks Leila!
My pleasure. Hope it will come in handy.
Great summary.
your video's are Great easy to understand
Excellent trick, thanks for sharing your exceptional knowledge of excel.
My pleasure Simoiya. Hope it will come in handy.
Thanks Leila. Great video as usual.
Thank you for your comment and dropping by.
Thanks for video!
Thanks for sharing... !! Great Tip
You're welcome Faraz :)
I like your voice Ma'am, really interesting to watch and effective.
Another great video, thanks Leila !!
My pleasure, John!
Thank you for the amazing training !!
Glad you liked it!
THANK YOU VERY MUCH MADAM.
I LEARNED NEW THINGS FROM YOUR VIDEO.
Glad to hear that.
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.
True - we have to make sure the end result isn't too small on the printed page. Thanks for your comment :)
SET PRINT AREA DID IT!!!!!!
YOU R AWESOME!!!
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 "
You save my life with my Boss Today thank you
Very good explain madam
Thank you,💐
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
Hi,
Its good question, i could solve it if you wana to auto change color or row cell etc
Very useful tips
Thanks Leila!
I totally LOL'd at that 0:56 "wasting trees" video insert.....NICE. :)
😁
Glad to see that you are addressing my novice problems. Thank you once again.
Glad to help. Hope it will come in handy.
@@LeilaGharani More than you know.
Good one😀 thanks 👍
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)😉
Always think before you print people! 🌲🌳 Awesome video! 😊
Very true. Glad you like the video!
Thank you Leila
I love your tutors
Firstly , Love your work Leila and find your videos absolutely fantastic. I've got a problem to solve in excel and haven't found a solution on the internet yet and was wondering if you could help.. perhaps an idea for your next video . I've got a model with 2 output sheets and these 2 sheets consists of 18 print formatted pages. Based on inputs by users , some of the pages may be blank , so i'm looking for a way to print only selected pages based on users input. just like you can in MS word or powerpoint..any guidance would be much appreciated.
great video!!!
thanks mam it is very helpful for me.
Thank you!
Thank you
Marvelous LG!!
Thank You.
Thanks Leila
Absolutley great
Amazing well explained clear my concept from INDIA
Excellent and a highly helpful video. Much useful than my college lectures.
Glad it was helpful!
very helpful
Love This
thank you from Egypte 🌹🌹
My crush! can't believe this! Every point sinks in!
Hi, it's really amazing, you absolutely a great teacher with good presentation skills, love your efforts....
Would like to ask you is there any options to use any formula to auto fill some colour to a row. Thank you and looking forward to hear you soon
Hi,
you can do this by applying new rule conditional formatting.
Its simple
nicely presented ..
Wirklich fantastisch Leila, diese Drucktricks sind sehr nützlich Viele liebe Grüße 🌞
Freut mich Katerina :)
I'm eagerly waiting for the next videos in the accounting series :)
They are in the works. We will restart next year :)
@@LeilaGharani Amazing, I can't wait for the LIFO FIFO video and much more others :D
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
Thank you :)
Thanks for this video's
You are my index in excel
Perfect