Tame your computer – take the backstage view

26 Sep

Have you ever tried to squeeze a few last rows or columns onto a single page? If so, you may have used the Scale to Fit options on the Page Layout tab to reduce the size of the worksheet to better fit the printed page.  (For example, if you select 1 page in the Width box and in the Height box select Automatic, all columns will appear on one page, but the rows could still be more than one page.)

But as you typically spot you need to make these tweaks when doing a Print Preview, why not use the Scaling options from the “Backstage view”?

Here’s how:

  1. Press CTRL + P to open “Backstage view”, from where you can preview and print files and (best of all) set options.
  2. From the No Scaling drop-down list select one of the following:
  • Fit Sheet on One Page
  • Fit All Columns on One Page
  • Fit all Rows on One Page

For example, if you select Fit All Columns on One Page your columns will appear on one page, but the rows may extend to more than one page.  If you have more than one page you may want to print a specific row or column as your title on every page of a printed worksheet; click on the Print titles button available from the Page Layout tab and follow the steps as described in tip 148 . (For some mysterious reason you cannot use this functionality if you click Page Setup from the Backstage view.)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: