General Worksheet Settings

Resolved · Low Priority · Version 2007

Wed 26 Oct 2011, 09:54 Delegate 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

Wed 26 Oct 2011, 10:59 Trainer Rodney said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

MS Project tip:

Using the Quick Access Toolbar in Project 2010

The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all MS Project hints and tips