View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?