Need to print formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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.
 
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


Adrian M said:
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 said:
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!!!
Click to expand...
Click to expand...
 
Thx.

--
Bonnie


Niek Otten said:
Hi Bonnie,

CTRL`


--
Kind regards,

Niek Otten

Microsoft MVP - Excel

Bonnie said:
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!!!
Click to expand...
Click to expand...
 
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
 
Back
Top