Displaying formulas in a worksheet

[Tom]

How do you display all of the formulas in a worksheet
instead of their values in Excel 2000?

 

[Frank Kabel]

Hi
goto 'Tools - Options - View' and check 'Formulas'

 

[Charles Williams]

Hi Tom,

Tools-->Options-->View-->Formulas or use the shortcut Ctrl `

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.

www.DecisionModels.com/FxlV2WhatsNew.htm

 

[David McRitchie]

Hi Tom,
An alternative to show all of the formulas used would be a formatted list.:
Creating a List of Formulas (Tip 37) , John Walkenbach's site
http://j-walk.com/ss/excel/tips/tip37.htm

Personally I find it much better to show some representative
working formulas right on the spreadsheet in another cell or
another column..
http://www.mvps.org/dmcritchie/excel/excel.htm

GetFormula(D14)
personal.xls!GetFormulaD(D14) -- when function in another workbook