Enter the number of pages wide and tall you want your spreadsheet to be when printed. Set the Scale to Fit options for Width and Height to the values you want.If you're using Excel 2007 and earlier for PC, or Excel for Mac 2008 or 2011In Excel 2007, click the Page Layout tab, then click the small arrow in the bottom right corner of the Page Setup group (this also works for Excel 2010 as an alternative to the instructions above)In earlier versions of Excel, and for Excel 20 for Mac, click File, then Page Setup. If you are going to print your notes, you can change the paper size to make sure everything fits on the.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. Scaling your spreadsheet when printingHow to Adjust Paper Size and Margins in OneNote. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page. Not only that, but Excel ignores any manual page breaks you've entered.Excel will ignore any vertical page breaks you've inserted when you do this, but will keep your manual horizontal page breaks.Of course, if you want the spreadsheet to print out just 1 page tall, and as many pages across as it needs, you'd reverse the values in steps 2 and 3 of method 1 above.Scaling to fit in other versions of Excel (PC and Mac)You can get the same result when printing from other versions of Excel for both PC and Mac. The number of pages it prints will depend on how many pages tall the scaled down spreadsheet is. It could also be that you have horizontal page breaks that you want to keep when you print your spreadsheet.Set the Scale to Fit option for Width to be 1 page.Set the Scale to Fit option for Height to be Automatic.Both methods will scale your spreadsheet so it prints out exactly one page wide. Scaling an Excel spreadsheet to a specific number of pagesSuppose you want your Excel spreadsheet to print out one page wide, but you don't mind how many pages tall the print out is. Not only that, but Excel ignores any manual page breaks you've entered.
![]() Excel Print Legal Size Paper Manual Page BreaksYou have cells outside the range you want to print that contain data. This will cause the technique outlined here to fail. You have manual page breaks in your spreadsheet. 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 should achieve what you're intending. When the Print options appear, make sure you're printing the selected cells only. 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. This can happen when you've entered data into a cell and then deleted it later. Sometimes cells look empty but aren't so they are included when printing your spreadsheet. Winzip for mac torrentThis article from Microsoft goes into more detail. 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. If this cell is way outside the range you are trying to print then you may want to reset this "last active cell".
0 Comments
Leave a Reply. |
AuthorKenneth ArchivesCategories |