how to print formulas onto paper

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fishberg - 18 Dec 2005 14:23 GMT

Can anyone tell me how to print not the result of a formula but the full
equation itself in a cell or series of cells? This will help me track down a
problem much easier than trying to do it on the screen. Excell Help is no
help. Excell Knowlege Base is no help. Maybe some smart good soul will
reply to fishberg@rcn.com Thanks!

Reply to this Message

Paul B - 18 Dec 2005 15:45 GMT

Fishberg, you can toggle formula and values by using Ctrl+`, the key next to
the number 1, you may also want to take a look at
http://j-walk.com/ss/excel/tips/tip37.htm with it you can make a worksheet
that contains a list of the formulas and their values.

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Can anyone tell me how to print not the result of a formula but the full
> equation itself in a cell or series of cells? This will help me track down a
> problem much easier than trying to do it on the screen. Excell Help is no
> help. Excell Knowlege Base is no help. Maybe some smart good soul will
> reply to fishberg@rcn.com Thanks!

Reply to this Message

Fishberg - 18 Dec 2005 17:18 GMT

Fantastic! Thanks! Now I realize Excel Help might have said this but I
tried the ' key next to Enter rather than the ` key next to number 1. How to
I rate this reply as GREAT!?

> Fishberg, you can toggle formula and values by using Ctrl+`, the key next to
> the number 1, you may also want to take a look at
[quoted text clipped - 7 lines]
> > help. Excell Knowlege Base is no help. Maybe some smart good soul will
> > reply to fishberg@rcn.com Thanks!

Reply to this Message

Paul B - 18 Dec 2005 21:24 GMT

Fishberg, no way to rate in this newsgroup, except for leaving feedback like
you did. Thanks

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Fantastic! Thanks! Now I realize Excel Help might have said this but I
> tried the ' key next to Enter rather than the ` key next to number 1. How to
[quoted text clipped - 11 lines]
> > > help. Excell Knowlege Base is no help. Maybe some smart good soul will
> > > reply to fishberg@rcn.com Thanks!

Reply to this Message