Excel Printing Problem - can't select Print area or Print Titles on Page Setup/Sheet Tab

J

John

Hi folks,

I am trying to use the "Print area" and "Print Title" selectors on the Sheet
Tab of Page Setup but they are greyed out. How can I make them active.

I have the same problem on two different computers each running Office 2000
Pro and one with a Windows 2000 Pro OS and the other with a Windows XP Pro
OS

Any tips on how to rectify this would be greatly appreciated.

Many thanks in advance
Doug
 
N

Niek Otten

You probably try to do that from the Print Preview menu. Doesn't work.
Use File>Page Setup instead.
 
C

cmcqueen

I cannot get the title option ungreyed out. Even using File>Page Setup.
Still greyed out there as well :confused:
 
C

cmcqueen

Found the answer myself. The sheet was grouped with another sheet. Once
ungrouped it was possible.:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Page Setup|Sheet 3
Page Setup: Sheet: Print Titles: Rows to Repeat at top 3
Disabled "Print column or row titles on every page" on the sheet tab in page setup. 4
"Print Titles" Disabled 1
Print titles in Excel XP 1
Printing On One Page Using Print-Area 6
Why is the Print Titles option in Page Setup:Sheet greyed out? 2
Why I get gray area in sheet tab of page setup? can't resize area. 1

Top