How do I print showing formulae written?

D

debbie

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.
 
D

Dave Peterson

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)
 
D

debbie

Thankyou so very much Dave, got me out of a big hole in my Association of
Accounting Technicians Assignment!!! Will be in touch!
 
Top