Print Area Grayed out

C

cornella1229

Using a Excel 2003 spreadsheet that's been converted to Excel 2007, I'm
trying to redefine the print area, but the "Print Area" option on the
Pagelayout tab is grayed out. I've tried selecting the entire spreadsheet
along with individual cells and can't get the area to become active. I've
gone into Sheet Tab within the Page Setup group and it also seems to be
inactive. Help?
 
C

cornella1229

Thanks JS. I was in normal view but you're suggestion made me try one other
thing.

Realizing I had "Freeze Panes" activated, I unactivated and now I'm able to
select the Print Area. I'll assume once I redefine my print area, I'll be
able to resume Freeze Panes.

Thanks for making me work a little more!!
 

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

Top