windows 2007 - excel 2007 print settings

Frank .S
Frank .S used Ask the Experts™
on
in excel 2007, under the page setup, under the "sheet" tab. The "print area" and "print titles" areas are disabled (will not allow me to select rows to repeat at the top of every page).
Please let me know how to change the settings so I can select these options when printing.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
You say the settings below are greyed out?

Excel-2007-Page-Layout
Try doing a Repair of Office. Go to Trust Center, Privacy Options, and check (select) the option to Download a File periodically from Microsoft. Then go to Help, Run Diagnostics and allow to complete.

See if that helps. These options are available to Standard Users, but the Repar may need Admin authority.

If a repair does not help, check a different Windows User Profile (userid) as the issue could be profile corruption.

Also consider uninstalling, restarting, and reinstalling Office 2007.

.... Thinkpads_User
Frank .SBuilding Estimator

Author

Commented:
Hi thinkpads_user,
thankyou for your reply, could you please tell me where "trust center" is so I can try your suggestion?
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Click on the Office "Funny" button (top left button) and select Excel Options. Once the Excel Options open, Trust Center is a menu on the left side. Then click on the Trust Center Settings button. This will show you the Privacy options.  The same thing is true in Word.

Please let us know if that does not get you to the Trust Center and then to the Privacy Options.

... Thinkpads_User
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Frank .SBuilding Estimator

Author

Commented:
Hi thinkpads, I have followed the 1st part of your directions but could you please tell me how to do the next part "Then go to Help, Run Diagnostics and allow to complete" I cant find help and dont know how to "run diagnostics", please give me step by step directions.
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Sorry. Office keeps changing and I am now using Office 2010.

In Excel Options (as per above), below Trust Center (as per above), is Resources. Click on Resources and see the Run Diagnostics line. Click on the button to run the Diagnostics. Allow to complete.

Please do ask if you need help. .... Thinkpads_User
Most Valuable Expert 2012
Top Expert 2012

Commented:
Just a thought - make sure you don't have more than one sheet tab selected when you try to set print area - this would definitely make the page setup icon greyed out.

Dave
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Thank you. I was pleased to assist. .... Thinkpads_User

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial