Print Preview - Excel
Since the Sheet options are not available from the Page SetUp dialog box when it is activated from the Print Preview feature, you should set any rows and/or columns you want to have repeated on each page before you go into the Print Preview mode.
There are two methods for entering the print preview mode:
1. Click on the Print Preview Button on the Standard Toolbar
2. Select Print Preview from the File menu
To Close the Print Preview feature, click on the Close button at the top of the window and Excel will return you to your worksheet.
It is a good idea to establish a methodical sequence for evaluating your Printed Report once you enter the Print Preview mode. Here is what works for me.
1. Look at the bottom border to discover how many pages will be generated
2. Use the Next and Previous buttons to determine what is contained on each of the pages and whether you need to adjust the page width options
3. Decide whether a portrait or landscape orientation best suits your report needs and set the page orientation if necessary. Close the Page SetUp dialog box to return to the Print Preview mode and evaluate the number of pages you now have if you have changed the orientation. Review the layout of the pages again.
4. Change the paper size if necessary
5. Next adjust the scaling if you are trying to get all columns on a single page width or if you want to reduce the number of pages wide.
6. After changing the scaling evaluate whether the print size will be too small
7. Change the margin to allow more space on the printer page if the scaling is too small
8. Click on the Page Break Preview to adjust the positioning of the page breaks
9. Return to Normal view. Review the Print Preview once again to determine if any further tweaking is necessary before printing.
The Print Preview feature provides you with all the tools you need to create the correct visual impact you want with your report lay out. It also keeps you from wasting time and paper when you have printed a worksheet only to discover that a column or a few rows have spilled over to another page.
Look for these related articles coming soon to learn more about how to use the options available in the Print Preview mode and the Page SetUp Dialog Box.
• Page SetUp Dialog Box
• Page Options
• Margin Options
• Headers and Footers
• Sheet Options
• Controlling Pagination
This site needs an editor - click to learn more!
You Should Also Read:
Page SetUp Dialog Box - Excel
Page Options - Excel
Sheet Options - Excel
Editor's Picks Articles
Top Ten Articles
Content copyright © 2019 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.