Printing Formulas

[htho9]

Is there a way to print the formula related to a cell? The precendent
and dependent functions don't provide enough detail for my boss, and my
boss doesn't like to look at things digitally.

I need to be able to show how the numbers are calculated on paper.
Please any suggestions would be greatly appreciated!

Thanks!

 

[JE McGimpsey]

Is there a way to print the formula related to a cell? The precendent
and dependent functions don't provide enough detail for my boss, and my
boss doesn't like to look at things digitally.

I need to be able to show how the numbers are calculated on paper.
Please any suggestions would be greatly appreciated!

Thanks!

One way:

Type Ctrl-` (that's the accent-grave, above the tab key and to the left
of the 1 on a standard US keyboard) to display functions rather than
values. You can print that out directly.

Another way would be to use something like I developed here to list
functions in all sheets to a separate sheet, including current values:

http://mcgimpsey.com/excel/listfunctions.html

you can see a screenshot here:

http://mcgimpsey.com/excel/pics/listformulas_scrnshot.gif