Subscribe to our Weekly Software Tips
Select Category:
Opening Office 2007 files in Office 2003
Cycling through all your windows
Cycling through your open Word documents
Spice up your Word documents with Page Borders
How to specify the formatting for new slides in PowerPoint
Unprotecting an Excel worksheet if you don't know the password
Getting Google to Define things for you
Set the default formatting for Shapes in PowerPoint
Restoring a missing column in an Outlook folder
Repeat column titles on every page when printing in Excel
Display a table's headings on each page in Word
Creating the same footer for several Excel worksheets
Selecting a large block of text in Word
Previewing your PowerPoint presentation
How to password-protect your screen saver
Printing only the last four pages of a Word document
Change the colour of a worksheet tab in Excel
Use the keyboard to move to the next placeholder on a PowerPoint slide
Getting the most out of Home and End
Shortcuts to insert the current Date or Time
Shortcuts for working with borders in Excel
Bypassing Outlook's Deleted Items folder
Which Taskbar button do I click on?
2010 Calendars from Office Online
Hiding zeroes in Excel
Subscriber Donna L. asks "How do you hide zeroes in Excel?"
If you have formulas that evaluate to zero, Excel has an option that lets you hide the zeros. This can give your spreadsheet a cleaner look and make it easier to see cells that contain non-zero values.
To hide zeroes in Excel 2003:
- Tools menu, Options, View tab
- Clear the Zero values check box
- Click on OK
To hide zeroes in Excel 2007:
- Office button, Excel options, Advanced category
- Scroll down to Display options for this worksheet
- Optionally select a worksheet
- Clear the Show a zero in cells that have zero value check box
- Click on OK
Any questions, please let me know.
Interested in Microsoft Excel Training in Vancouver?