Call us on 01223 214177 or email us
Have you ever tried to squeeze a few last rows or columns on 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:
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 (tip_148.html) . (For some mysterious reason you cannot use this functionality if you click Page Setup from the Backstage view.)
.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.