Forum home » Delegate support and help forum » Microsoft Project Training and help » General Worksheet Settings
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
General Worksheet Settings
Resolved · Low Priority · Version 2007
Reply Wed 26 Oct 2011, 09:54Delegate James said...
James has attended:
Excel Intermediate course
General Worksheet Settings
In 2003 you can set the worksheet to 'not display' and zero values - how can you do this using 2007
For upcoming training course dates see: Pricing & availability
RE: General Worksheet Settings
Hello James,
Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.
Thank you for your question regarding how to hide the zero values in Excel 2007.
This is simply an options setting that needs to be changed. Go to the Office button and select Excel Options at the bottom and choose the Advanced group and scroll down to 'Display options for this worksheet' and uncheck the fourth check box. Click OK and you're done.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
|