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

Posted by:submeg

Musician, Writer and Inspirer. I discuss the projects I am working on, the services I provide and my general thoughts.

Tell me what you think!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s