Printing all formulas in a workbook
 

Is there a way to print all the formulas in a workbook?

Printing all formulas in a workbook
 

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

"gimeabrek071" wrote in message
...
Is there a way to print all the formulas in a workbook?

Printing all formulas in a workbook
 

is there an eaiser way?

"Bernard Liengme" wrote:

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

"gimeabrek071" wrote in message
...
Is there a way to print all the formulas in a workbook?

Printing all formulas in a workbook
 

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 F5SpecialConstantsOK

EditClearContents

Print the sheet

Do this for each sheet.


Gord Dibben MS Excel MVP

On Fri, 17 Aug 2007 16:10:07 -0700, gimeabrek071
wrote:

is there an eaiser way?

"Bernard Liengme" wrote:

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

"gimeabrek071" wrote in message
...
Is there a way to print all the formulas in a workbook?