T
Tom
How do you display all of the formulas in a worksheet
instead of their values in Excel 2000?
instead of their values in Excel 2000?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
goto 'Tools - Options - View' and check 'Formulas'
goto 'Tools - Options - View' and check 'Formulas'
C
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
Tools-->Options-->View-->Formulas or use the shortcut Ctrl `
regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
D
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
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