Excel Worksheet Tips: Switch Between Formula and Results

By

Excel Worksheet Tips: Switch Between Formula and Results

If you have created a worksheet in excel with formula all over the sheet and want to quickly see what the formulae are, use:

Ctrl + ~

(Where ~ is tilde; which is located underneath the Esc key)

You can even print in this mode and the formulae will show rather than the result. To switch back to results mode, just press the combination again.

Come check out the directory for the rest of my excel tips!

Submeg

IT

Advertisements