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.

How do you shrink to fit in word 2013