So you’ve spent a long time making this excel sheet and formulating it’s cells for your future needs.

In the rush of work you’ve fed the empty cells with numbers and saved over the original file -the one for general purposes – and now you are busted in tears :’(

Wipe your nose for God’s sake, there is actually a way to select only cells with numbers, skipping all cells with formulas and text:

1) On your keyboard press (F5) or (Ctrl + g) and a (Go To) window will popup.
2) Click on (Special) button.
3) Click on (Constants) and uncheck everything from (Text) down to (Errors) leaving (Numbers) checked.

Note: take a moment to see all the other selections you may need for other scenario’s, you never know when you’r gonna need them(Ex. like selecting all the formula’s of text).

4) Click (Ok) and all the required fields are selected and with a one (Delete) press on your key board they are all empty again.

Here are some hotchicks……Err, I mean hotkeys you might wanna know:

  • (CTRL+`): Switch between numbers-View and Formulas-View in all Cells.
  • (CTRL+` or F4): Repeats last possible command or action.
  • (CTRL+;): Enters the current date into selected cell.
  • (Alt+ Enter): For a new line within a cell (don’t be surprised a lot of people don’t know that).