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

What is VBA in Excel?

VBA VBA, which stands for Visual Basic for Application, is a programming language developed to work with Microsoft’s Office applications

Read More »
Scroll to Top