Display Formula and Value Simultaneously

Ever need to display a formula and value simultaneously in the same spreadsheet?

This could not be easier to do in excel. In the example below, the shortcut to display a formula is Ctrl `

Before each formula, you can place a “`” in front of the “=” sign. When you

When you are done, hit Ctrl ` again. Now the formula still remains.

Scroll to Top