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

SECOND Function

The SECOND function in Excel returns the second component of a specified time as a number between 0-59. Syntax: =SECOND(serial_number)

Read More »
Scroll to Top