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:
a. Fit Sheet on One Page
b. Fit All Columns on One Page
c. 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.)
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
24 September 2013
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at http://www.roem.co.uk
The Learning Collaboration and Cambridge Network members have the opportunity to book places at a reduced rate.
_____________________________________________________