Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Page Layout Tab

Themes - Page Setup - scale to fit - sheet options - arrange

EXCEL 2010 PAGE LAYOUT RIBBON

Scale to Fit

EXCEL 2010 SCALE TO FIT GROUP

The Scale to Fit functions in Excel will come in handy when you have a couple of rows or columns going to an additional page, and you want them to all fit on a single page.

You can use the Width, Height and Scale options in the Scale to Fit section of the Page Layout tab to change these settings.

EXCEL 2010 SCALE TO FIT ONE PAGE




In our image to the right, we can see that rows K, L and M are set to print on a second sheet.

Change the drop-down menu next to Width and Height from Automatic to 1.

Now, when we go to File and Print, we can see that our entire document is set to print on one page (as shown in the image below).

EXCEL 2010 SCALE TO FIT PRINT PREVIEW

The Scale option in the Scale to Fit section allows you to stretch or shrink the printed output to a percentage of its actual size.

The Width and Height options must be set to Automatic to utilize the Scale option. Type the desired percentage in the field next to Scale or use the up and down arrows.

In our example, we will input 50% into the field. As you can see in the image below, our data becomes fairly small and perhaps hard to read. You can increase or decrease the percentage as needed.

EXCEL 2010 SCALE TO 50%
Next Tutorial


This concludes the Scale to Fit tutorial.
Click next to continue to the Excel 2010 Sheet Options tutorial.