Microsoft KB Archive/912069

= You cannot set the print area and the print titles when you view a print preview of a worksheet in Excel =

Article ID: 912069

Article Last Modified on 1/10/2006

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-





SYMPTOMS
When you view a print preview of a Microsoft Excel worksheet, the following print options are unavailable (appear dimmed) on the Sheet tab of the Page Setup dialog box:
 * Print area
 * Rows to repeat at top
 * Columns to repeat at left

Additionally, the Set Print Area command on the File menu may be unavailable when multiple worksheets are selected.



WORKAROUND
To resolve this issue, follow these steps:  Close the print preview. Make sure that only one worksheet is selected. The print options that are unavailable in the print preview are also unavailable when you select multiple worksheets. To set these print options, you must select a single worksheet. For more information about how to determine whether multiple worksheets are selected, click the following article number to view the article in the Microsoft Knowledge Base:

291310 Some print settings are unavailable when you select multiple sheets in Excel 2002 or Excel 2003

 On the File menu, click Page Setup. Click the Sheet tab. Make sure that the print options that were unavailable in the print preview are now available. Then, configure the settings that you want.



MORE INFORMATION
For more information about print settings for worksheets in Excel 2003 and Excel 2002, click Microsoft Excel Help on the Help menu, type define what part of the worksheet to print in the Search for box in the Assistance pane, and then click Start searching to view the topic.

For more information about print settings for worksheets in Excel 2000, click Microsoft Excel Help on the Help menu, type change the worksheet area that appears on a printed page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: XL2003 XL2002 XL2000

Keywords: kbtshoot kbprint kbsettings KB912069

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.