print worksheet with formulas displayed?

[condliffe]

Can you print a worksheet with the formulas displayed in Excel 2000? It's
very simple in Excel XP...through 'formula auditing', but I cannot find how
or even "if you can" do the same in Excel 2000!!! HELP!!!!!!!!!!!!!

 

[Paul B]

condliffe, Ctrl+` will toggle between valves and formulas, or tools options,
view and check formulas
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Gord Dibben]

If you would like them printed in a new worksheet along with cell addresses
and results, use John Walkenbach's ListFormulas code.

http://j-walk.com/ss/excel/tips/tip37.htm

Gord Dibben Excel MVP