View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I print showing formulae written?

Save your workbook first (this is gonna mess it up!).

Tools|Options|View tab|check Formulas

Adjust the column width to what you want.

Print the workbook
(you may want File|Page Setup|Sheet Tab|check row and column headings)

===
Depending on the version of excel, you can add the full path to a footer/header
(also under File|page setup|header/footer tab|custom header (or custom footer).

If you're running xl2k or below, you could use John Walkenbach's addin:
http://j-walk.com/ss/excel/files/addpath.htm
to add the path in the header/footer

You could also use a formula in a worksheet cell:
=cell("Filename",a1)
(but the workbook has to be saved)

debbie wrote:

I need to print documents showing the actual formulae written and can't find
how to do it! I also need to print documents showing the file location and
storage.


--

Dave Peterson