MC Home - ISC Home - Help Documentation - Report Manager - Prepare a Report for Printing in Excel

Prepare a Report in Excel for Printing

Overview
Delete Unnecessary Columns
Change the Worksheet Orientation
Change the Worksheet Margins
Reduce the Font Size
Shrink the Data to Fit on One Page

Overview

Before you print a report in Excel, you should view the worksheet in Print Preview to see what the printed report will look like.

If the data does not fit on one page (and you want it to), then you can try:

• Deleting unnecessary columns
• Changing the worksheet orientation
• Changing the worksheet margins
• Reducing the font size
• Shrinking the data to fit on one page

Delete Unnecessary Columns

1. Right-click on the column letter and select Delete.
   
   

Change the Worksheet Orientation

1. On the Page Layout tab, click on Orientation and select Landscape.
   
   

Change the Worksheet Margins

1. On the Page Layout tab, click on Margins and select the desired option.
   
   

Reduce the Font Size

1. Click the Select All button.
   
   
   
2. On the Home tab, click the font size down arrow and select a smaller font size.
   
   
   
   Note: After you change the font size, you should resize all of the columns to best fit the data again. To do this, click on the Select All button and then double-click on the vertical line between any two column letters.
   
   

Shrink Data to Fit on One Page

If you have one or two columns that appear on another page, then you can try shrinking the data so that they will fit on the same page as the other columns.

To shrink data:

1. On the Page Layout tab, click on the Width down arrow and select 1 page.
   
   
   
   Note: Shrinking the data shrinks the data on the printed page, not on the worksheet. After you shrink data, you should view the worksheet in Print Preview to make sure that the data is not too small to read.