how to print formulas onto paper Fishberg 18.12.2005 14:23:02 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[ at ]rcn.com Thanks!

Re: how to print formulas onto paper "Paul B" <to_much_spam_to_list[ at ]nospam.com> 18.12.2005 15:45:30 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. -- 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 "Fishberg" <Fishberg[ at ]discussions.microsoft.com> wrote in message news:DBD9642C-EAA4-4AED-BA26-DD021F64FC1E[ at ]microsoft.com... [Quoted Text] > 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[ at ]rcn.com Thanks!

Re: how to print formulas onto paper Fishberg 18.12.2005 17:18:02 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!? "Paul B" wrote: [Quoted Text] > 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. > > > -- > 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 > > "Fishberg" <Fishberg[ at ]discussions.microsoft.com> wrote in message > news:DBD9642C-EAA4-4AED-BA26-DD021F64FC1E[ at ]microsoft.com... > > 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[ at ]rcn.com Thanks! > > >

Re: how to print formulas onto paper "Paul B" <to_much_spam_to_list[ at ]nospam.com> 18.12.2005 21:24:49 Fishberg, no way to rate in this newsgroup, except for leaving feedback like you did. Thanks -- 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 "Fishberg" <Fishberg[ at ]discussions.microsoft.com> wrote in message news:5FFF57AB-AD64-40C7-AF6C-90486CD4885B[ at ]microsoft.com... [Quoted Text] > 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!? > > "Paul B" wrote: > > > 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. > > > > > > -- > > 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 > > > > "Fishberg" <Fishberg[ at ]discussions.microsoft.com> wrote in message > > news:DBD9642C-EAA4-4AED-BA26-DD021F64FC1E[ at ]microsoft.com... > > > 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[ at ]rcn.com Thanks! > > > > > >