PDA

View Full Version : [SOLVED] Printing formulas (on your printer!)



Shrout1
09-30-2004, 06:49 AM
Is there some way to print the formulas that are contained in the cells rather than the actual data that is contained within them?

I have a small workbook that shows me how three different sheets relate to each other (i.e. the formulas reference example pages, etc.) I have to mirror the architecture in this workbook, and it would be a lot easier to do if I could simply print out the formulas.

Just curious! Thanks!

JKwan
09-30-2004, 08:02 AM
Don't know if this is really what you want, however, it will do the trick....
go CTRL + "~" , this will change your "normal" view to "Formula" view, then just print it.

Zack Barresse
09-30-2004, 08:16 AM
Here is another option, a UDF to show what your formula is showing ..

http://www.vbaexpress.com/kb/getarticle.php?kb_id=62

mdmackillop
09-30-2004, 09:33 AM
Tools/Options/View Tick Formulas

Shrout1
09-30-2004, 11:37 AM
Works great! Thanks!