I have and this is the first time I've seen the shrink to fit. When you change the values for Fit to, the data will shrink to fit the specified number of pages. Diane Poremsky said: It think it always defaults to shrink to fit when you print from the web but you should be able to click it and change it to 100.
If you have set any manual page breaks, these will be ignored when you use the ‘fit to’ option To view how the data will look on the page, view a print preview first Now all you need to do is print as normal. On the Page Layout tab > Page Setup group > Orientation > choose either ‘ Portrait’ or ‘ Landscape’ Here’s how in Word 2003 and Word 2007: Word 2003: Click inside the table. In order to use this setting, the height and width options must be set to automatic.ĭepending upon the size and shape of your data, it may be better to change the orientation of the page to print your spreadsheet landscape rather than portrait. It’s particularly useful if you ever change the page margins in your document with a table set to ‘autofit to window’, changing the page margins means that the table resizes too and you don’t have to resize the columns manually. Scale the dataĪlternatively, in the same group settings here you can set the ‘scale’ percentage, which is set to 100% by default, to stretch or shrink your data to a percentage of it’s actual size. Note: you will see the the ‘scale’ option is greyed out once you have changed settings for the width and height – the percentage will be altered automatically for best fit to your requirements. In this example, we want the data to fit one A4 page, so we will select 1 page wide and 1 page high as in the example below. Adjusting the left/right margins can also help fit more text on a page but it’s less direct than the top/bottom margins.
By default these are set to ‘automatic’ but if you click the dropdown arrows here you are able to choose how many pages high or wide you want your data to be. There are two dropdown boxes – one for width and one for height.
On the Page Layout tab > Scale to fit group you will see a number of options Define the number of pages to print onįirst, open the worksheet the you want to print This command opens the Set Image Print Resolution dialog that allows you to change the dimensions of a printed image and. On the right, click the “Choose Commands From” drop-down menu and select the “All Commands” option.Now and again you might want to print out the contents of a spreadsheet worksheet, perhaps for an attendance list or address database for an event.Įxcel spreadsheets don’t really have default settings to have them print nicely on a standard A4 page, as you might find in Word, and you will have probably experienced the issue of printing your spreadsheet to find the rows split over multiple pages – often wasting paper and making the information hard to read.īy scaling a worksheet in page setup before you print, you can control its width and number of pages, there are two ways of doing this: 1.
, how to print exact size in word, how to reduce print size in word, how to scale a document in. In the Word Options window, the “Quick Access Toolbar” category should already be selected on the left. Note: You cannot scale the document to fit the paper. On the drop-down menu, click the “More Commands” option. Go ahead and click the down arrow at the far right of the Quick Access Toolbar. That’s the little toolbar at the top left of your window with the Save and Undo command. The easiest way to do this is to add it to your Quick Access Toolbar. The “Shrink One Page” command isn’t on the Ribbon by default, so you’ll need to add it. While you can undo the command if things don’t look right, we’d encourage you to save your document first to be on the safe side. But in other circumstances, it’s worth giving a try. If you’re working on a document (like a school essay) where you must use a required font or margin size, this command probably won’t work well for you. You can restore this 'classic' print preview screen, which also happens to contain the Shrink to Fit button as shown in Figure 4: Click the arrow at the end of the Quick Access Toolbar and then choose More Commands. Then click the OK button to confirm and save the changes. Then enter the Width and Height for A5 Paper Size as 5.8 and 8.3 respectively. In the Page Setup window, navigate to Page Size and set the value for the drop down to Custom Size. Then select the More Paper Sizes from the list. The “Shrink One Page” command works by automatically sizing down your text and adjusting margins to shrink your document just enough. Click the drop down with value displayed as Letter. Have you ever written a Microsoft Word document and found that your last page contains just a few sentences and a bunch of white space? Instead of editing your work down, you can try a nifty hidden feature in Word that might solve the problem.