Setting the "print area" in a spreadsheet

P

Phil James

I have a file in which I'd like to re-set the print area. On most files I
have no problem with this. On this particular file, there's nothing in the
"print area" nor the places where you set the rows or columns you want to
print on every page. The space is not white, as it usually is, but a
strange light blue color. Nothing I've tried lets me do anything in those
areas.

Has something been "set" inadvertently? How do I "un-set" it?

Phil
 
G

Gord Dibben

Phil

If you are attempting to do this while in "Print Preview" mode the print area
and row to repeat will be unavailable.

Go in through File>Page Setup"Sheet.


Gord Dibben MS Excel MVP
 
Top