Thursday 6 December 2012

Switching display between formula in cells to results of the formula

Don't panic if you accidentally hit your keyboard and find that all the cells in Excel are displaying its formula instead of their results.

All you need to do is to press Ctrl + `    Note: ` <- this symbol refers to the key on the left side of 1.

Have fun!