Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excell hiding zero's

Excell hiding zero's

ResolvedVersion Standard

Thu 5 Feb 2009, 13:17 Delegate jane said...

jane has attended:
Excel Intermediate course

Excell hiding zero's

how do i hide the zero's in a document

Thu 19 Mar 2009, 11:26 Trainer Rajeev said...

RE: excell hiding zero's

Dear Jane

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

Please choose Tools > Options...

In the View Tab under the Window options section untick Zero Values.

Press OK

All your zeros will be hidden!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excell hiding zero's

Excell hiding zero's

RE: excell hiding zero's

Excel articles

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook