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

  • Thread starter Thread starter John
  • Start date Start date
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
 
You probably try to do that from the Print Preview menu. Doesn't work.
Use File>Page Setup instead.
 
Thank you for reply Niek, you nailed it in 1.

Many thanks again
Doug
 
I cannot get the title option ungreyed out. Even using File>Page Setup.
Still greyed out there as well :confused:
 
Found the answer myself. The sheet was grouped with another sheet. Once
ungrouped it was possible.:)
 
You must log in or register to reply here.

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
imposiible to print comments, neither titles 3
Page Setup: Sheet: Print Titles: Rows to Repeat at top 3
Excel won't print 2
Printing problem 5
Print Area setup with Formula resetting 2
Printing footnotes in Excel - active printed area 1
Duplex printing 7

Back
Top