Question for Excel experts...

[superboyac]

I have a spreadsheet that was written by someone a long time ago, and I'm kind of trying to reverse engineer it.  I'm trying to see what he's doing by following the formulas.  But there are so many cells to navigate through...is there some kind of way to generate a list that tells me what the formula in each cell is?  Something like

Cell M1 = A1+B1
Cell M2 = A2+B2

And so forth.  I just want a list so I can quickly follow everything without having to jump around forever.

Thanks for any help.

[Carol Haynes]

Not sure if you can do that but you can printout the spreadsheet with the formulae in the cells rather than the results.

[tsaint]

I have a spreadsheet that was written by someone a long time ago, and I'm kind of trying to reverse engineer it.  I'm trying to see what he's doing by following the formulas.  But there are so many cells to navigate through...is there some kind of way to generate a list that tells me what the formula in each cell is?  Something like

Cell M1 = A1+B1
Cell M2 = A2+B2

And so forth.  I just want a list so I can quickly follow everything without having to jump around forever.

Thanks for any help.

-superboyac (February 08, 2006, 05:57 PM)

Tools/options/View Tab  .... check the view formulae box

[superboyac]

Thanks.  I found out it was the "Ctrl" + "~" combo that toggles the formula box you mentioned.  Very cool!

[dajo]

Also, be sure to check out the Formula Auditing toolbar (View: Toolbars).  It will draw arrows to and from dependent cells.

[kfitting]

Another cool tool (though it isn't the Cat's Meow!) is an auditing add-in I found yesterday.  Go to http://vangelder.orcon.net.nz/ go to his Excel page (using the bar on the left) and look for "AudXL 1.10 Add-In."  I dont like the way it formats formulas, but it's a cool idea and has given me some of my own.  Excel is extremely powerful, a cheaper replacement than MatLab in any event!

Incidentally, if anyone is tired of the Excel sort order I am almost finished with a module that does a natural sort in excel.  It can also sort by cell or font color and allows more than four columns (no real limit...).  Let me know,

Kevin

Kevin

[KaysLover]

I would be interested.

Please PM with the details when done.

Regards

Kayslover.

[superboyac]

Also, be sure to check out the Formula Auditing toolbar (View: Toolbars).  It will draw arrows to and from dependent cells.

-dajo (February 08, 2006, 09:22 PM)

Wow!  Awesome.

[superboyac]

Another cool tool (though it isn't the Cat's Meow!) is an auditing add-in I found yesterday.  Go to http://vangelder.orcon.net.nz/ go to his Excel page (using the bar on the left) and look for "AudXL 1.10 Add-In."  I dont like the way it formats formulas, but it's a cool idea and has given me some of my own.  Excel is extremely powerful, a cheaper replacement than MatLab in any event!

Incidentally, if anyone is tired of the Excel sort order I am almost finished with a module that does a natural sort in excel.  It can also sort by cell or font color and allows more than four columns (no real limit...).  Let me know,

Kevin

Kevin

-kfitting (February 09, 2006, 05:42 AM)

Cool!  Yes please let me (us) know more about it.

[kfitting]

Ok... give me about another day and I'll have it as a stand alone add-in.  Unless a major bug is found, however, I will not be offering support! 

[kfitting]

Add-In is now available.  Check out https://www.donation...dex.php?topic=2413.0 for more details.

Kevin