How to print Excel spreadsheet on one page

Рет қаралды 84,753

Күн бұрын

Learn how to fit all your columns and rows on to one page in Excel, INCLUDING why Page Break’s not working. Scaling your data to suit your printout requirement can save a lot of time, and a lot of paper! In this tutorial you will learn how to fit your Excel sheet on one page for printing. You’ll also learn why Insert, Page Break may not be working.
Timestamps:
mm:ss
00:00 How to print Excel spreadsheet on one page
01:42 Using the Show Margins preview to adjust the margins and column widths
02:32 Scaling the Excel worksheet to print to only one page
03:18 Adjusting the Scaling options
03:57 Understand why Insert, Page Break isn’t working
05:13 Adjust the print area using the Page Break Preview
Topic #41 in the ‘Steps to becoming Proficient in Excel’ workbook.
👀 Read the full text article here: www.excelatwork.co.nz/2021/05...
🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: excelatwork.co.nz/subscribe/ 🔔
❤ VERSION FRIENDLY ❤
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.
#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelatWork

Пікірлер: 43

@ExcelatWork 3 жыл бұрын

Need help scaling to fit a spreadsheet on one page? Let Sharyn help.

@Gsnoop440 5 ай бұрын

You are the best! I have looked and read numerous articles about how to print excel spreadsheets and have never figured it out. Now by watching your video in less than 3 min I am finally able to print it. THANK YOU VERY MUCH!!

@ExcelatWork 4 ай бұрын

Yayyyy!!! Awesome, thank you!

@collee2075 3 жыл бұрын

Thank you so much for this great tip :-)

@user-ks5cg5cd7m 3 жыл бұрын

Very helpful channel. Thank you for clear explanations.

@ExcelatWork 3 жыл бұрын

Thanks Faith! Really appreciate your comment and so happy to have been of help. Sharyn 😊

@No_Plastic 2 жыл бұрын

Fantastic, thank you!

@ExcelatWork 2 жыл бұрын

You're very welcome!

@girishhate3877 3 жыл бұрын

thanks lady any more of your work i will be keen to follow

@ExcelatWork 3 жыл бұрын

Awesome! Thank you!

@abdallahkambangwa7215 2 ай бұрын

thanks you very much.

@ExcelatWork 2 ай бұрын

You are welcome. So glad it helped!

@opokubismark6425 2 жыл бұрын

Very helpful...Thank you

@ExcelatWork 2 жыл бұрын

Fantastic. So glad it helped 😊

@kevinmillicent 2 жыл бұрын

Thank you for sharing

@ExcelatWork 2 жыл бұрын

My pleasure

@stephonharris8789 2 жыл бұрын

Thank You so much.

@ExcelatWork 2 жыл бұрын

You're most welcome

@ZiryabHamid Жыл бұрын

love it thanks

@ExcelatWork Жыл бұрын

So glad Ziryab!

@InHomeTutoringHonolulu 2 жыл бұрын

Good tricks thank you.

@ExcelatWork 2 жыл бұрын

You're welcome!

@NoziM0686 3 жыл бұрын

Thank you 😊❤️

@ExcelatWork 3 жыл бұрын

You’re welcome 😊

@shrs.3448 2 жыл бұрын

Thank you.

@ExcelatWork 2 жыл бұрын

You're welcome!

@Afro_spices Жыл бұрын

Thanks😊

@ExcelatWork Жыл бұрын

You're welcome ☺️

@shaurishauri7786 Жыл бұрын

Most videos shown are for vertical printing in one page. How about printing in a horizontal form? As I tried in horizontal form, the columns are no longer have the same size. Thanks.

@barbra429 2 жыл бұрын

I'm learning Excel and have two questions. Can I use this technique, but I want the grid lines to show on my printout. How can I show them. Is there a way to put some Clipart and pictures etc at the top of the printout if I want it to look a bit more decorative or if I want to put my logo on it?

@ExcelatWork 2 жыл бұрын

Hi Barbra. To print your gridlines, go to the Page Layout Tab and under the Gridlines heading place a check in the Print box. Yes, you can add your logo at the top. First resize and save your logo so that it will fit nicely at the top of the page, then from the Insert Tab click Header- & Footer. Click into the section of the Header where you would like to place the logo. You will see a Picture option on the Ribbon. Click this and upload your logo into the Header. You can click out of the Header area when you are finished but you may still be in the Page Layout view where you can see your logo. To go back to your normal view you may need to go to the View tab and set your view back to Normal. I hope this helps :-)

@barbra429 2 жыл бұрын

@@ExcelatWork Thanks so much

@dylanbyrne4048 2 жыл бұрын

I've been trying to get my semester planner assignment to fit on one A3 page, when I try to print it will not come out large enough but there is still plenty of room on the A3 page. I have tried adjusting the font sizes, and when I went 72 max font it's too large, it only prints half of the content to one page even when I have set it to print on one page. I have spent over a week re editing over and over again. I know there is a way to get the content to come out nice and visible and readable because there is still more room on the A3 page, but when I Have the font set to roughly 16 it was still not very readable.😱 I am going to give up I've been at the library until past midnight the last two nights trying to do this, It is part of my assignment requirements to fit it to 1 page. I know there is just something easy within the print settings or on the actual printer settings.

@ExcelatWork 2 жыл бұрын

Hey Dylan. How frustrating for you. I'm sorry I have only just read your message. Forgive me if you have already checked this a million times, but is your Paper Size set to A3 (Page Layout tab > Size > A3)?

@mollydog444 2 жыл бұрын

In your example all the text seems mostly to the left on the page. How can it be made to look more evenly spread across the page? Also how do you print with horizontal lines only?

@ExcelatWork 2 жыл бұрын

Hi there. Both are excellent questions. Here are a couple of things to try. For question #1, try increasing your left margin. You may need to fiddle with this a bit until you get it right. Question #2, try applying a middle border to your cell range. To do this, select over the range where you want the horizontal line, from the Home tab click the Borders button > click More Borders. The Borders option box will open. Look for 3 buttons placed vertically under the heading 'Borders'. Click the middle button. This should place a boder into the middle of the preview box. Click OK and you will now have horizontal borders, no vertical borders, so when you print on the horizontal lines will print. I hope this helps.

@shubhsingh4905 2 жыл бұрын

@@ExcelatWork kindly make a video on these question to understand properly.

@ExcelatWork 2 жыл бұрын

Hi there. I've just published a video that will help you balance your worksheet when printing. I hope this is helpful to you kzfaq.info/get/bejne/or2VmqSEkt3YfHk.html