Viewing Formulas instead of formula results

[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?

 

[Paul B]

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 **

 

[Max]

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?

 

[Peo Sjoblom]

It is actually ctrl + ` (grave accent) since tilde is returned
if you press shift (US keyboard layout)

 

[loafer]

You could try using an application like EXChecker.

http://www.spreadsheetauditing.com

 

[steve]

from another post -

You can also use Chip Pearson's PrintFormulas Code to print all the formulas
of your selected
range to a Word document - See the following link:-

http://www.cpearson.com/excel/excelM.htm#PrintFormulas

steve