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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend