Print area won't change

  • Thread starter Thread starter Terri
  • Start date Start date
T

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!
 
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
 
Thanks for trying but it didn't work. I removed all of the formatting and I
still get the Print Area options greyed out.
 
Have you tried the File, Page setup, Sheet from the toolbar, this is
different that from the print preview options.
 
I tried using that method but when I click on the icon to select the print
area, nothing happens.
 
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?
 
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
 
Thank you! That did the trick!

Gord Dibben said:
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.
Click to expand...
Click to expand...
 
Back
Top