Shrink One Page is a fairly blunt instrument that can’t handle long documents or more complex formatting (pictures, tables, charts) very well. Why isn’t Shrink One Page more commonly used? In the above example, 12pt text changes to 11pt. Shrink One Page reduces the font size and sometimes line spacing a little to make the excess text fit. Here’s a simple two-page document with only two lines at the top of the second page.Ĭlick on Shrink to Fit and, presto!, you have a one page document. Shrink One Page does what the name suggests, it will make a document slightly smaller so an ‘orphan’ part at the top of a page will fit at the bottom of the previous page. You can add it to a ribbon or Quick Access Toolbar. At the time, it was the pride of Office product demos but now languishes in the All Commands list. Shrink One Page or Shrink to Fit was added to Word a long time ago, at least a decade. Making a document that’s using part of an extra page (an ‘orphan’), fit into a single page or one less page. #How to shrink to fit in word 2013 how to#If so, it is the button above Page Setup), then click the Fit Sheet on One Page option.ĭo you need to print a blank grid from Excel, but are having trouble getting the program to print cells that don’t have any data in them? Learn how to use print areas in Excel 2013 to start printing empty tables and grids.The Shrink to Fit or Shrink One Page option hiding in Microsoft Word might solve a common problem. Step 4: Click the No Scaling button at the bottom of the center column (that is its default setting, but you may have previously changed it. Step 3: Click Print in the column at the left side of the window. Step 2: Click the File tab at the top-left corner of the window. Step 1: Open your spreadsheet in Excel 2013. Click the No Scaling button at the bottom of the center section, then click the Fit Sheet on One Page option.Click the Print option in the column at the left side of the window.Click the File tab at the top-left corner of the window.You can then click the OK button at the bottom of the window to apply your changes. Step 4: Click the circle to the left of Fit to, type 1 into the first field, then type 1 into the second field. Step 3: Click the small Page Setup dialog launcher at the bottom-right corner of the Scale to Fit section in the ribbon. Step 2: Click Page Layout above the ribbon at the top of the window. Step 1: Open your worksheet in Excel 2013. You can then click the OK button at the bottom of the window. Click the circle to the left of Fit to in the Scaling section of the ribbon, then adjust the values so that it says 1 page(s) wide by 1 tall.Click the small Page Setup button at the bottom-right corner of the Scale to Fit section of the ribbon.Step 4: Click the Height drop-down menu under the Width drop-down, then click 1 Page. Step 3: Click the Width drop-down menu in the Scale to Fit section of the ribbon, then click the 1 Page option. Step 2: Click the Page Layout tab above the ribbon at the top of the window. Step 1: Open the spreadsheet in Excel 2013. Click the drop-down menu to the right of Height, then click 1 Page.Click the drop-down menu to the right of Width, then click 1 Page.Click the Page Layout tab at the top of the window.You may want to consider simply choosing to fit all of your columns or all of your rows on one page instead. For very large spreadsheets, this can be difficult to read. Each method is presented first as just the steps, then it is repeated with pictures.Įach of these methods is going to fit your entire spreadsheet on one page. We will show you each of those methods below. There are three different ways that you can fit a spreadsheet to one page in Excel 2013. Our guide below will show you three different ways that you can accomplish this.įitting an Entire Worksheet on One Printed Page in Excel 2013 One way around this is to force Excel 2013 to fit your entire worksheet on one page. Occasionally you will get lucky and the number of rows or columns in your spreadsheet will match up perfectly with the dimensions of your printed page, but more often than not, you will have one column or one row that adds another page, or even doubles the number of pages. Excel spreadsheets typically don’t print the way that you want them to.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |