How to Get Excel to Fit on One Page
Our Comment Policy.
We welcome your comments and questions about this lesson. We don't welcome spam. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through. We know that bots don't read messages like this, but there are people out there who manually post spam. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours. One other point to note - if you post a link in your comment, it will automatically be deleted.
Add a comment to this lesson
.
Comments on this lesson
Excel Printing
I am quite a savvy Excel user....however, I can't for the life of me get my spreadsheet to print properly on one page. It is printing in about 60-70% of the page, no matter how I set up the margins or set to print 1 page by 1 page. Basically it looks as though there is a bottom margin of 1"+ and a right margin of 1"+. (but top and left are small, as i set them at .25") The data is not too tall or too wide to fit more appropriately. I have cleared the print are and set it again, changed margins, changed to print 1 by 1 page, i have even tried to adjust the excel chosen % from 55 to 56 and it immediately jumps to two pages.
I'm having this same problem
I'm having this same problem and can't for the life of me figure out what's going on... I have all the setting where they should be and even the print preview is showing everything normal... but when I print, it comes out "big" and only the top left quarter of the document prints...
Look at the Paper Size. I
Look at the Paper Size. I had a report that I received that had 'Legal' and I was trying to print on 'Letter'. I changed the Paper Size to Letter and it worked fine.
Excel 2013
Unfortunately Excel 2013 doesn't "agree" when I make these adjustments. It still forces part of my document on to a second page. I thought new would be better, NOT !!
How I did it
View; page break preview; drag blue line to where you desire page margin in print to be. Hope this helps ppl
How I did it
Helpful tip
Thanks for the helpful tip! View --> Page break review --> drag margin.
It worked! Thank you so much
It worked! Thank you so much - it was very frustrating trying to get Excel 2013 printed correctly (not too small).
File>Print Preview>drag margin over was the solution for my issue!
The number of pages it prints
The number of pages it prints will depend on how many pages tall.
Excel page prints too small
Great ideas on fixing this annoying problem; unfortunately, none of them work. Page still prints very small in the center of page, or prints on several pages. But, it's Microsoft, so what do you expect.
There's always a reason it won't work!
Hi Otto
Sounds like it's working as designed, except Excel is getting confused about what you want to print and including cells that you don't want to include in the printout.
There are a couple of possibilities that might be causing you to have problems:
- You have manual page breaks in your spreadsheet. This will cause the technique outlined here to fail.
- You have cells outside the range you want to print that contain data. These are included when Excel determines the range of cells that should be printed, causing your spreadsheet to appear very small.
- Sometimes cells look empty but aren't so they are included when printing your spreadsheet. This can happen when you've entered data into a cell and then deleted it later. If you had formatted the cell and then only deleted the values in the cell, then Excel can be confused and think that the cell is still part of the range it should print.
The easiest way to test the second and third scenarios is to select just the cells you want to print. When the Print options appear, make sure you're printing the selected cells only. This should achieve what you're intending. If it does, then you need to review your spreadsheet for data that should be excluded when printing.
Another way you can test for the presence of extra or "empty cells that Excel thinks aren't empty" is to press CTRL+SHIFT+END. This will locate the last cell in the worksheet that Excel recognises as part of your working area. If this cell is way outside the range you are trying to print then you may want to reset this "last active cell". My solution in this case is usually to manually delete empty rows and columns around my spreadsheet that are within the active range but contain no data. This article from Microsoft goes into more detail.
Let me know how you get on!
Regards
David
Worksheet vs Print Preview
Worksheet and print preview do not agree. The worksheet will add an extra empty line when the text is close to another cell while print preview sees it as ok when manually setting the position of the gridline.
I think it is not working.
I am doing the worksheet for my class, It does not work even I tried.
I am trying to print a page, but instead of printing the page it's printing every cell separately on the page yes I've tried to reset the print area no good
I am trying to print a page, but instead of printing the page it's printing every cell separately on the page yes I've tried to reset the print area no good
Printing first page from multiple excel files
I have around 300 different excel files in one folder of my computer. I want to print the first page of all these files. Is there a way for me to do it all at once or do I have to open every single file and print the first page individually?
Scaling in Microsoft Excel is not working
I'm trying to scale down 100% page into 75% in Microsoft Excel 2010 spreasheet. But, whenever i put 75% in the page layout, i'm the size of the sheet is remain same - no change at all.
I have tried other option - drag the page line (Blue line) to the place where i want to fix the page setup in Page Break view... that also not working.
Using the same option, i have printed 1000s of pages. Now, someone plz guide me - how to resolve this error?
Excel
.
.
.
How to Get Excel to Fit on One Page
Source: https://fiveminutelessons.com/learn-microsoft-excel/scale-your-spreadsheet-fit-one-page-when-printing-excel
0 Response to "How to Get Excel to Fit on One Page"
Post a Comment