How to Fit an Excel Sheet on One Page

You can easily alter your spreadsheet's width or height

Rate: (1 Ratings)

It can be frustrating when you are trying to print out a spreadsheet from Excel and it prints on several pages. Rather than tape them together for a huge, barely manageable worksheet, follow these tips to print your Excel spreadsheet on one page (or as many pages as you wish).

Flag Article

Instructions

Difficulty: Moderately Easy

Step1

Open the Excel spreadsheet that you want to print. Click on “File” in the Excel toolbar, or use the keyboard shortcut Alt+F.

Step2

From the “File” menu, choose “Page Setup."

Step3

In the “Page Setup” dialog box, click the “Page” tab.

Step4

Under “Scaling”, click the radio button to the left of “Fit To."

Step5

Enter your desired number of pages in the “Pages Wide” and “Pages Tall” drop-down menus. For example, you may want to change only the width of your page so that the last columns do not print onto a separate page. In this case, you would enter “1” into “Pages Wide” and delete the number in the “Pages Tall” menu.

Step6

Click OK. Your Excel spreadsheet will now fit the way you want it to.

Tips & Warnings

By selecting "Page Break Preview" from the "View" menu, you can see exactly how your spreadsheet will print. To go back to the normal view, simply select "Normal" from the "View" menu.