Print Area Grayed out
 

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?

Answer: Print Area Grayed out
 

It sounds like the worksheet may be protected, which can prevent changes to the print area. Here are some steps you can take to try and resolve the issue:

1. Check if the worksheet is protected. Go to the Review tab and see if the "Unprotect Sheet" option is available. If it is, click on it and enter the password if prompted. This should allow you to make changes to the print area.
   
2. If the worksheet is not protected, try selecting a range of cells that you want to set as the print area. Then, go to the Page Layout tab and click on the "Print Area" option. From the drop-down menu, select "Set Print Area". This should define the selected range as the print area.
   
3. If the "Print Area" option is still grayed out, try going to the "Page Setup" dialog box. You can access this by clicking on the small arrow in the bottom right corner of the "Page Setup" group on the Page Layout tab. In the "Page Setup" dialog box, go to the "Sheet" tab and check if the "Print Area" section is grayed out. If it is, try unchecking the "Print" option under "Print Area". This should allow you to define a new print area.
   
4. If none of the above steps work, try saving the file as a new workbook and see if the "Print Area" option is available in the new file. If it is, you can copy and paste the data from the old file to the new one and define the print area there.

I hope these steps help you resolve the issue with the print area.

Print Area Grayed out
 

You must be trying this in Print Preview mode.

Try it from workbook file menu FilePageSetupSheet tab
--
If this post helps click Yes
---------------
Jacob Skaria


"cornella1229" wrote:

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?

Print Area Grayed out
 

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


"Jacob Skaria" wrote:

You must be trying this in Print Preview mode.

Try it from workbook file menu FilePageSetupSheet tab
--
If this post helps click Yes
---------------
Jacob Skaria


"cornella1229" wrote:

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?