Excel - Show Formulas

Submitted by Tech-Karma on Sat, 06/11/2011 - 09:00

To show ALL FORMULAS in Excel, hit (CTRL+ `)

aka CTRL + Grave Accent

Where grave accent is the key next to the number one (1) key.  The grave accent is just underneath the tilde at the upper, left-hand side of most keyboards.

This action will replace all cells that contain formulas with the actual formula text instead of the formula results.  Hit (CTRL + `) again to restore the fomula results.

Share this page on Facebook!      

Comments

Post new comment

  • HTML tags will be transformed to conform to HTML standards.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <p>
  • Lines and paragraphs break automatically.
  • You may quote other posts using [quote] tags.
  • You may insert captions with [caption]IMAGE caption[/caption]. You can also align an item with [caption align=left].

More information about formatting options