Viewing Formulas instead of formula results

  • Thread starter Thread starter Meghan
  • Start date Start date
M

Meghan

I want to view all of the formulas in my worksheets
without going through each cell and typing " " around each
formula. Is there any way to do this so I can check all
of my formulas at once?
 
Meghan, here is one way, use Ctrl and ~, this will toggle between formulas
and results

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Short-cut: Press Ctrl + ~ (Tilde key - the one above Tab key). This gives
you the formula view. Repeat to toggle back to normal view.

Alternatively: Click Tools>Options>View tab. Check "Formulas" under
Window options > OK.

| I want to view all of the formulas in my worksheets
| without going through each cell and typing " " around each
| formula. Is there any way to do this so I can check all
| of my formulas at once?
 
It is actually ctrl + ` (grave accent) since tilde is returned
if you press shift (US keyboard layout)
 
Back
Top