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
 

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
Can't change print area 1
Setting print area 1
Setting print area for entire workbook 1
Excel 2007 Multiple Print Areas 0
Removing the print area dost from the screen 2
one particular cell in a print area will not print out 1

Top