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 Reply

ISERROR Function

The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!,

Read More »


The SUMPRODUCT function in Excel is a useful tool when you are working with large data sets or multiple arrays. 

Read More »
Scroll to Top