Printing and Print Previewing

1. Overview

By default, choosing Print prints the entire current worksheet using the content options defined in Print Worksheet > Content.

2. Printing a Range of Cells

Select the desired range and choose Selection in Print Worksheet > General.

3. Printing Selected Pages

Specify the list of pages in Print Worksheet > General.

The list may contain single pages or ranges separated by commas, e.g.:

1,2,4-8,10

4. Printing an Inserted Chart or Image

Select the object before choosing Print. Charts are automatically stretched or shrunk to fit the printed page.

5. Adding Headers and Footers

In Print > Layout, enter header/footer text using these special codes:

&pCurrent page number
&p+numberPage number plus “number”
&p-numberPage number minus “number”
&fFull file path
&aWorksheet name
&dCurrent date
&tCurrent time
&&Literal ampersand

6. Changing the View Scale in Print Preview

Click Zoom In, then right‑click and drag to select the rectangle to zoom into.