Need to print formulas

[Bonnie]

Hello all! Using E02 on XP. Have linked cells in OutFile.xls 'reading' data
from InFile.xls. Rather than handwrite my cell mapping, how can I print the
linked cells or the formulas?

Example: InFile has:

A B C
1 10.45 9.32 3.25
2 9.87 5.98 5.32
3 12.87 10.11 7.42

OutFile has:

D L
V
10 ='S:\[InFile.xls]P4'!A1 ='S:\[InFile.xls]P4'!B1
='S:\[InFile.xls]P4'!C1
22 ='S:\[InFile.xls]P4'!A2 ='S:\[InFile.xls]P4'!B2
='S:\[InFile.xls]P4'!C2
36 ='S:\[InFile.xls]P4'!A3 ='S:\[InFile.xls]P4'!B3
='S:\[InFile.xls]P4'!C3

Rather than print my InFile and resulting values from OutFile (showing row
and col numbers) and handwriting the mapping (=A1, =B2, etc.) I would like to
print the formulas as you can see above. Hope I'm explaining this well
enough so anyone reading can understand.

Thanks in advance for any advice or help!!!

 

[Niek Otten]

Hi Bonnie,

CTRL`


--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[Adrian M]

If I understand you correctly you can hold the CTRL key while pushing on the
~ key (on my keyboard it is to the left of the 1 key). This will show the
underlying formulae in all the cells which you can then print. To see a video
clip of how to do this you can go to
http://www.auditexcel.co.za/tips and tricks.html and look at the first
section (show the underlying formulae). Hope I understood you correctly.

 

[Bonnie]

Hi Adrian,

You understood perfectly! Thank you VERY much for the extra bit of
explanation. I will go check out the video example if I have any trouble.
This will save me BEAUCOUP time writing out my mapping.

Thanks for the quick reply! LUV U GUYS!!!
--
Bonnie

If I understand you correctly you can hold the CTRL key while pushing on the
~ key (on my keyboard it is to the left of the 1 key). This will show the
underlying formulae in all the cells which you can then print. To see a video
clip of how to do this you can go to
http://www.auditexcel.co.za/tips and tricks.html and look at the first
section (show the underlying formulae). Hope I understood you correctly.

Hello all! Using E02 on XP. Have linked cells in OutFile.xls 'reading' data
from InFile.xls. Rather than handwrite my cell mapping, how can I print the
linked cells or the formulas?

Example: InFile has:

A B C
1 10.45 9.32 3.25
2 9.87 5.98 5.32
3 12.87 10.11 7.42

OutFile has:

D L
V
10 ='S:\[InFile.xls]P4'!A1 ='S:\[InFile.xls]P4'!B1
='S:\[InFile.xls]P4'!C1
22 ='S:\[InFile.xls]P4'!A2 ='S:\[InFile.xls]P4'!B2
='S:\[InFile.xls]P4'!C2
36 ='S:\[InFile.xls]P4'!A3 ='S:\[InFile.xls]P4'!B3
='S:\[InFile.xls]P4'!C3

Rather than print my InFile and resulting values from OutFile (showing row
and col numbers) and handwriting the mapping (=A1, =B2, etc.) I would like to
print the formulas as you can see above. Hope I'm explaining this well
enough so anyone reading can understand.

Thanks in advance for any advice or help!!!

 

[Bonnie]

Thx.

--
Bonnie

Hi Bonnie,

CTRL`


--
Kind regards,

Niek Otten

Microsoft MVP - Excel

Hello all! Using E02 on XP. Have linked cells in OutFile.xls 'reading'
data
from InFile.xls. Rather than handwrite my cell mapping, how can I print
the
linked cells or the formulas?

Example: InFile has:

A B C
1 10.45 9.32 3.25
2 9.87 5.98 5.32
3 12.87 10.11 7.42

OutFile has:

D L
V
10 ='S:\[InFile.xls]P4'!A1 ='S:\[InFile.xls]P4'!B1
='S:\[InFile.xls]P4'!C1
22 ='S:\[InFile.xls]P4'!A2 ='S:\[InFile.xls]P4'!B2
='S:\[InFile.xls]P4'!C2
36 ='S:\[InFile.xls]P4'!A3 ='S:\[InFile.xls]P4'!B3
='S:\[InFile.xls]P4'!C3

Rather than print my InFile and resulting values from OutFile (showing row
and col numbers) and handwriting the mapping (=A1, =B2, etc.) I would like
to
print the formulas as you can see above. Hope I'm explaining this well
enough so anyone reading can understand.

Thanks in advance for any advice or help!!!

 

[David McRitchie]

Hi Bonnie,
If you are having trouble with formulas or just want to document them
I find them a lot more useful if they are included on the same printed
page or displayed in another cell somewhere, whether it be an
adjacent column simply one representative formula. See
GetFormula and GetFormulaD user defined functions in

Show FORMULA or FORMAT of another cell
. http://www.mvps.org/dmcritchie/excel/formula.htm