Print area won't change

[Terri]

I am tearing my hair out -- please help! I have an Excel 2003 worksheet which
I originally created for my previous years' taxes. I added a column for this
year, copied and revised the formulas and now want to change the print area
and the page breaks. I can't get the print area to include the new column and
the page break border won't drag. When I try to copy and paste the data into
a new file, I get the message that the command can't be done with multiple
cells. I can't figure this out -- what am I missing? The original file was
recovered from a disk defrag problem about 6 weeks ago. Could the file be
corrupted and that's why it's doing this? I need this spreadsheet!

 

[Don Guillett]

If desired, send to my address below and I'll take a look

 

[RobM]

Sounds to me that somewhere on your sheet there are some merged cells.
Try clicking on the top left corner of the shhet and selecting Format,
Cells, Alignment, then de-selecting from the text control area the merged
cells box.

Rob

 

[Terri]

Thanks for trying but it didn't work. I removed all of the formatting and I
still get the Print Area options greyed out.

 

[RobM]

Have you tried the File, Page setup, Sheet from the toolbar, this is
different that from the print preview options.

 

[Terri]

I tried using that method but when I click on the icon to select the print
area, nothing happens.

 

[RobM]

On the sheet try pressing the Alt key and hold it, then press F, let both
keys go, the press U. This should bring up a page set-up dialogue box. Is
this box greyed out as well?

 

[Gord Dibben]

I'm thinking you have more than one worksheet selected.

Do you see [Group] on the title bar?

If so, right-clcik on any sheet tab and "Ungroup sheets"


Gord Dibben MS Excel MVP

 

[Terri]

Thank you! That did the trick!

I'm thinking you have more than one worksheet selected.

Do you see [Group] on the title bar?

If so, right-clcik on any sheet tab and "Ungroup sheets"


Gord Dibben MS Excel MVP

I tried using that method but when I click on the icon to select the print
area, nothing happens.