How to Properly Print an Excel File - Printing Problems Solved!
HTML-код
- Опубликовано: 30 июл 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😎
Wow !! What would I have done without you!! Thank you so much for such amazing videos
As always, you're the best!!
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!
OMG I wish I knew you sooner. You are my life saver!! Please release more episodes for us to follow !!
Will do 😊
Your videos are really great, helpful.
I needed this one.
Thanks a lot
great video... an additional useful tip is the shortcut 'Ctrl + F2' for a quick print preview.
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.
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.
You are a great source of inspiration.
Thank you very much.
In Honor!
Jason
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.
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 :)
God bless you Leila, thank you very much!
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.
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 :)
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!
I've watched other tutorials on RUclips and didn't learn anything. Watched yours and GOT IT. Great explanation, THANK YOU!
Happy to hear that!
Thanks Ms Leila for another great video.
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 a lot, Leila, your videos are really helpful, crisp, and clear.
Glad you like them!
Very helpful! But do you have a video on resolving the problem of shapes being distorted when printing, e.g. circles printing as ovals?
Thanks you for your help! You're always useful
Greats tips. Thank you Leila.
This really solved my problem which has been going on since long time.
Thank you for the video
I found this video very helpful, it has solved a lot of things , Thank 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
Thanks Leila! You are a saviour.
I highly recommend this channel for the one who really want to improve their excel skills..
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.
Thanks for the knowledge session.
I enjoy her explain step by step and have subtitles
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.
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 :)
Very useful video specially for the finance people work in companies...
Thanks Leila...Happy Holidays to you and your family...
Thanks Matt. Same to you and your loved ones.
I know almost all these tips except for page breaks. It is a good way to adjust the page breaks.
Very good explain madam
Thank you,💐
Amazing, i learnt something new from you.
Love your channel, love your work! Recommended to most of my colleagues.
Thank you very much!
Very helpful tips. Thanks Leila!
My pleasure. Hope it will come in handy.
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)😉
Love this! Perfect 👍🏻
Excellent trick, thanks for sharing your exceptional knowledge of excel.
My pleasure Simoiya. Hope it will come in handy.
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 like your voice Ma'am, really interesting to watch and effective.
Thanks Leila. Great video as usual.
Thank you for your comment and dropping by.
Another great video, thanks Leila !!
My pleasure, John!
Wirklich fantastisch Leila, diese Drucktricks sind sehr nützlich Viele liebe Grüße 🌞
Freut mich Katerina :)
thank you so much, that page break preview thing was what i was lookin for
Glad I could help!
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
your video's are Great easy to understand
Phew! I love this &
I LOVE YOU
You made me fell confident and independently handle my worksheet. thank you for the Amazing content
You're so welcome!
You made it sound so simple and easy! Thanks
You're welcome!
You explain in supper easy way that what i like so much.
Thank you Laila.
Happy to hear that!
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
Great summary.
Thank you Leila
Thanks Leila!
Thank you for the amazing training !!
Glad you liked it!
Addicted to your vids xxx
Always think before you print people! 🌲🌳 Awesome video! 😊
Very true. Glad you like the video!
thanks mam it is very helpful for me.
Amazing well explained clear my concept from INDIA
Here's a problem I haven't been able to figure out. Can you use a slicer to change the row source for a pivot table/chart? In other words, being able to switch the grouped rows from using column B to column C, and so forth.
Thank you. The substance starts at: 2:57
SET PRINT AREA DID IT!!!!!!
YOU R AWESOME!!!
Very useful tips
Thanks for video!
Thanks Leila
You save my life with my Boss Today thank you
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.
THANK YOU VERY MUCH MADAM.
I LEARNED NEW THINGS FROM YOUR VIDEO.
Glad to hear that.
I love your tutors
Thank you
Thank You.
Good one😀 thanks 👍
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 "
Excellent and a highly helpful video. Much useful than my college lectures.
Glad it was helpful!
Hi Leila, I’m new to your channel and you have already helped with so many of my issues. Apologies if you have answered my question already. I have developed an excel document with custom margins, which fits perfectly on my print preview. When I send the document to my team, in print preview the pages do not fit correctly due to the margins set to normal. Is there a way of my document being opened up by other users using my custom settings?
thank you from Egypte 🌹🌹
Thanks for sharing... !! Great Tip
You're welcome Faraz :)
Marvelous LG!!
My crush! can't believe this! Every point sinks in!
great video!!!
Love This
very helpful
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.
شكرا
Thank you!
Thanks for this video's
Absolutley great
nicely presented ..
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