Print area won't change

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!
 
R

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
 
T

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.
 
R

RobM

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

Terri

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

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?
 
G

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
 
T

Terri

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...
 

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 Area Setting 1
Print Area 2
Set Print Area 1
Print Area 2003 and 2007 1
Another Print Area question 3
Print Area Grayed out 1
Excel 2007 not calculating margins & print area correctly 7
Print multiple Area and wrap together 1

Top