Tips Tagged as: excel

Hide ugly errors in Excel

If your Excel formula returns an error, you usually end up with something rather unattractive like #VALUE! in the Cell. If you want to hide this from your users, you can simply drop your formula into this IF statement...

=IF(ISERROR(YourFormula),"",YourFormula)

The IF statement looks for an error in your formula. If it finds one, it blanks the cell. Otherwise, it puts the result of your formula.

For example, if your formula was A2*B6, you would write....

=IF(ISERROR(A2*B6),"",A2*B6)

There are no comments about this tip. Add a Comment

About This Tip

Added: 24th Jun 2007

(Rated by 3 people)

Author: Neil

Tags: excel

Rate This Tip

Insert today's date in an Excel cell

You can quickly add today's date or time into an Excel spreadsheet by pressing:

Date: Ctrl+Semicolon
Time: Ctrl+Shift+Semicolon

To get Excel to update the sheet everytime you open it with today's date, just put the following into the formual bar of the cell...

=TODAY()

There is 1 comment about this tip. Read/Add a Comment

About This Tip

Added: 24th Jun 2007

(Rated by 1 person)

Author: Neil

Tags: excel

Rate This Tip

Highlight a row or column in Excel

You can highlight the entire rows or columns of the selected cells in MS Excel quickly using keyboard shortcuts...

Highlight column: Ctrl+Spacebar
Highlight row: Shift+Spacebar

There are no comments about this tip. Add a Comment