In Excel, it is easy to preview what the layout will look like when printed without actually printing.
The print image displayed on the screen is called the "Print Preview". You can display the Print Preview even if your printer is not connected to your computer.

Reading this article, you will learn how to show the Print Preview and how to use it. This article consists of the following two pages.

• Preparation

• Let's display the Print Preview

• Let's zoom in on the Print Preview using the Ribbon

• Click Print Preview, and then let's zoom in on the Print Preview

Preparation

Open the table you created previously in "Let's create 'Series' data", and let's preview the print image. Open the saved worksheet.

Practice: How to open a workbook For information on how to open a book, refer to "Let's save and open a worksheet".

 Top of Page

Let's display the Print Preview

1. Click the (Office Button), point to Print, and then click Print Preview.

   

2. A print preview of the worksheet is displayed.

   

Tip: For a multi-page worksheet When there are multiple pages in a worksheet, you can click Next Page in Preview on the Print Preview tab to display the next page of the print preview. You can also click Previous Page on this tab to display the previous page.

 Top of Page

Let's zoom in on the Print Preview using the Ribbon

The Print Preview is displayed first with the one page displayed in the entire window.
You can zoom in on the display and check the page at the 100% zoom setting.
Using Zoom in the Ribbon, let's zoom in on the display.

1. [Click Zoom in Zoom on the Print Preview tab.

   

2. The zoom setting changes to 100%.

   

3. [Click Zoom in Zoom on the Print Preview tab.

   

4. The Print Preview display returns to the original zoom setting.

   

 Top of Page

Click Print Preview, and then let's zoom in on the Print Preview

You can click Print Preview and zoom in on the display.

1. Place the cursor over the worksheet in Print Preview.
2. Confirm that the cursor shape has changed to , and then click on the print preview.

   

3. The Print Preview display is magnified, and the cursor shape changes to .

   

4. Confirm that the cursor shape has changed to , and then click on the print preview.
5. The Print Preview display returns to the original zoom setting.

   

 Top of Page

"Let's change the page orientation and quit Print Preview" are next.