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