Is there a simple work around? > > "marc chamoun" wrote: > > > On Sep 1, 11:26 am, stan-the-man > > <> wrote: > > > I have a wide For example, you may need to change the page orientation from portrait to landscape or target a larger paper size. Excel 2007 > > programmers need to come up with a fix that will permanently fix this issue, > > otherwise, I foresee that I will have to delete and reinstall In my research, it appears to be a long-term MS Excel problem reaching back at least 2 versions form 2007, 2003 and 2002 (at least). this contact form
Go to the File menu and click Page Setup. While I cannot vouch for Stan's solution from the blog site, I was able to fix the problem by shutting down everything, restarting the computer, and then it all worked as reply There's always a reason it won't work! You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet. http://www.pcreview.co.uk/threads/excel-2007-print-scaling-not-working.3880238/
Consider using a larger paper size to accommodate a lot of printed columns. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher next to Page Setup. The Page Setup dialog box appears. How To Shrink An Excel Spreadsheet To Fit On One Page Columns will now appear on one page, but the rows may extend to more than one page.
Member Login Remember Me Forgot your password? Excel Scale To Fit Not Working but when I print, it comes out "big" and only the top left quarter of the document prints... Enter the number of pages wide and tall you want your spreadsheet to be when printed. For example, you may choose to set your spreadsheet to be 1 page wide and 2 Similar Threads Excel 2007 beta does not print headers and footers Guest, May 31, 2006, in forum: Microsoft Excel Crashes Replies: 1 Views: 263 Nick Hodge May 31, 2006 Chart Line
Regards David reply Frozen Panes Submitted by Scott on Tue, 11/26/2013 - 04:57 Also make sure that you UNFREEZE all panes you have frozen before you print. http://www.brighthub.com/computing/windows-platform/articles/70085.aspx At present I'm considering just changing printers to avoid the problem. How To Make An Excel Spreadsheet Fit On One Page Excel will ignore any vertical page breaks you've inserted when you do this, but will keep your manual horizontal page breaks. How To Print Excel Sheet In A4 Size If so, I shall bow out, that thing is buggy, at best.
Start with the page orientation. How Click the View tab on the ribbon and then click Page Layout. Add a comment to this lesson Comments on this lesson Excel Printing Submitted by Visitor on Tue, 11/27/2012 - 06:11 I am quite a savvy Excel user....however, I can't for the I hope this helps you out. -- MJ "TomL" wrote: > Having the same issue, very frustrating. How To Make An Excel Spreadsheet Fill The Whole Page
Share Share this post on Digg Del.icio.us Technorati Twitter Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog Reply With Quote Apr 13th, 2011,07:00 PM #3 new4me New Member Join Date Something in the upgrade did not work. 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. In my situation I only have one problem worksheet.
This doesn't mean there is no solution. How To Make Excel Spreadsheet Bigger When Printing Alternatively, press ALT+P, S, P. Any other feedback?
I've also been printing to a PDF then printing the PDF to the Toshiba printer. northben's blog Search form Facebook Ben NorthwayCreate Your Badge Bitcoin tip jar If you found my blog useful, you can send me some Bitcoin. :) 12rR3uqD8YTBDA3gQMtn8dNZxxicSkPKKn Skip to main content Five reply The number of pages it prints Submitted by Marian on Wed, 11/06/2013 - 19:23 The number of pages it prints will depend on how many pages tall. How To Print Excel Sheet On One Page 2010 To see how much scaling is used, look at the number in the Scale box.
It is not economy to print only one column or one row on one paper. If you don't want to unfreeze the rows or columns in your worksheet, you can skip Page Layout view and instead use the Fit to options on the Page tab in Under Scaling, click Fit to. Instead of consolidating the data onto > > > one page, it page breaks into 30 pages with bizaar margin settings I did not > > > choose, the font size
Yes No Great! Print your spreadsheet. You might need to change your Print Driver. In the first Fit to box, enter 1 to fit the worksheet to the width of one page.
muckshifter posted Nov 14, 2016 at 9:34 AM Black Friday starts today! To do this, go to Page Layout > Page Setup > Orientation, and click Landscape. Sometimes cells look empty but aren't so they are included when printing your spreadsheet. Submitted by Andrea on Sat, 07/05/2014 - 02:50 I am doing the worksheet for my class, It does not work even I tried.
We welcome your comments and questions about this lesson. You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. Tip: To reduce a worksheet to fit the printed pages, enter a percentage that is smaller than 100%. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Apr 13th, 2011,06:44 PM #2 NateO Legend Join Date Feb 2002 Location Minneapolis, Mn, USA Posts 9,701 Re: The
Top of Page Print a worksheet on a specific number of pages Click anywhere in the worksheet that you want to print. Thinking this a printer driver issue. No problem. > > > > In Excel 2007 I do the same thing, set the scaling to fit to one page wide > > by one page tall and it All contents Copyright 1998-2016 by MrExcel Consulting.
You can use the Width, Height, and Scale options in the Scale to Fit group of the Page Layout tab to change these settings. To clarify, you need to erase the values in the "print titles" fields so that the rows and columns are not repeated on every page.