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

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.