Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - print cell source? 2

Status
Not open for further replies.

JustLJ

MIS
Oct 15, 2002
70
US
Greetings.
I'm using Excel 2007, in case it matters for the situation.
In dealing with a workbook made up of 42 different worksheets, there are many cross populations occurring in that one piece of cell data will be used in a formula to feed a value and that value used in another worksheet, etc. We've all done that one way or another.
I'm interested in being able to list, document, print, etc. what the source of a value in a cell is.
For example, you have a summary sheet and in A1 is sheet30!A44 and in A2 is sheet32!B96, etc. You can tell that by going to A1 and the source shows in the value line.
I want to be able to print that sheet showing what the source of A1 is, not the resulting value there... and for all the cells on that sheet.
In essence, I want to be able to build a documentation listing of this cross pollination.
Any thoughts about how one would achieve this result?
Thank you for your time and consideration.
LJ
 
Show Formulas? Ctrl+` (left single quote, below the tilde, or next to the 1)
 
Hi LJ,

a fast method:
- press Strg+# (in a German Excel 2003 it works)
or tick [Formulae] in Extras > Options > View*
- the sheet should now print out the sources.

The column width is set to 64 when formulae are shown, but returns to it's original size when values are shown.

Hope this suits your needs.

Markus
____________________
* All menu commands were re-translated in English. Hope I got them right.
 
Thank you both I had no idea and apologize it was something so easy!

Markus4 - I'm not sure what the "strg" is, but I located the view on the menu bar.

Gruuuu - yes, exactly; my brain wasn't processing the source as a formula. Time to go back to Excel 101!

Thanks again for sharing and not being snarky about it!

LJ
 
JustLJ,

maybe you noticed that Gruuu and I answered at about the same time. But it takes me a time to translate everything, and yes, I completely overlooked Strg.

It's the abbreviated literal German translation Steuerung of Control/Ctrl.

Thank you anyway.

Markus
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top