G
gimeabrek071
Is there a way to print all the formulas in a workbook?
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.
B
Bernard Liengme
My favourite way is with Chip's macro:
http://www.cpearson.com/Excel/excelM.htm#PrintFormulas
Need help with VBA? See David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
http://www.cpearson.com/Excel/excelM.htm#PrintFormulas
Need help with VBA? See David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
G
gimeabrek071
is there an eaiser way?
Bernard Liengme said:My favourite way is with Chip's macro:
http://www.cpearson.com/Excel/excelM.htm#PrintFormulas
Need help with VBA? See David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
G
Gord Dibben
No.
Chip's macro would be quite easy.
If you mean "without using VBA" there is a method but not very easy.
Make a copy of your worksheet then
Hit CTRL + `(backquote above Tab key)
This will put you into View Formulas.
Now F5>Special>Constants>OK
Edit>Clear>Contents
Print the sheet
Do this for each sheet.
Gord Dibben MS Excel MVP
Chip's macro would be quite easy.
If you mean "without using VBA" there is a method but not very easy.
Make a copy of your worksheet then
Hit CTRL + `(backquote above Tab key)
This will put you into View Formulas.
Now F5>Special>Constants>OK
Edit>Clear>Contents
Print the sheet
Do this for each sheet.
Gord Dibben MS Excel MVP