When you’re sifting through a ton of critical figures in Excel, there’s certain data you really don’t need to see — like all of those zeros. Luckily, there’s an easy way to make them disappear.
Out of sight
If you’re using Excel 2007, and you want to hide the extra zeros that aren’t a necessary part of the data you’re working with, it’s a fairly straight-forward process. But you’ll need to set this function for each sheet in your workbook.
Here’s how to do it:
- Click the Office button in the top-left corner and select Excel Options
- Pick Advanced from the left pane
- Under the Display Options for This Worksheet section, uncheck the box next to Show a Zero in Cells That Have Zero Value, and
- Click OK.
And then enjoy working without the distraction of all those zeros.
If you’re looking for more Excel tips and shortcuts, TechRepublic has a wealth of info. If you’d like to share a tip of your own, feel free to post it in the Comments section or contact one of our editors.