How to Preview an Excel Worksheet

By eHow Computers Editor

Rate: (0 Ratings)

Before you print your Microsoft Excel spreadsheet, it is important that you preview what the spreadsheet will look like once it is printed. By using "Print Preview" you can see what the spreadsheet will look like printed and be able to make some basic changes to it. Doing this can save you both time and wasted paper. The steps below will walk you through previewing your Excel worksheet.

Flag Article

Instructions

Difficulty: Easy

Things You’ll Need:

Microsoft Excel 2003

Step1

Start Microsoft Excel and open a spreadsheet that you are ready to print.

Step2

Choose the "File" menu. Select "Print Preview" to enter "Print Preview" view.

Step3

Navigate through your Excel spreadsheet pages by using the "Next" and "Preview" buttons at the top of the "Print Preview" view.

Step4

Zoom on your Excel spreadsheet by clicking the "Zoom" button while in the "Print Preview" view. Click on "Zoom" once to magnify the spreadsheet page you are on. Click it again to return to full-page view.

Step5

Print the spreadsheet by clicking the "Print" button to exit "Print Preview" and bring up the "Print" dialog box.

Step6

View the formatting specifics of your spreadsheet by clicking the "Setup," "Margins" and "Page Break Preview" buttons. The "Setup" button will open the "Page Setup" dialog box, the "Margins" button will show the current margins of the spreadsheet and the "Page Break Preview" will show the location of each page break.

Step7

Use the "Help" button if you need more help and then click the "Close" button to exit "Print Preview" and return you to your spreadsheet.

Tips & Warnings

You can also enter "Print Preview" view by clicking the "Print Preview" button on the standard toolbar, depicted by the picture of a magnifying glass.
Click anywhere on your spreadsheet while in "Print Preview" to zoom between magnified and full-page view.