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

[Niek Otten]

Hi Bonnie,

CTRL`


--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Bonnie" <bonnielynnw@discussions.microsoft.com> wrote in message
news:6704AC7D-17C5-45B1-9673-805EA759218F@microsoft.com...
> 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

[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%20and%20tricks.html and look at the first
section (show the underlying formulae). Hope I understood you correctly.

"Bonnie" wrote:

> 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

[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


"Adrian M" wrote:

> 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%20and%20tricks.html and look at the first
> section (show the underlying formulae). Hope I understood you correctly.
>
> "Bonnie" wrote:
>
> > 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

[Bonnie]

Thx.

--
Bonnie


"Niek Otten" wrote:

> Hi Bonnie,
>
> CTRL`
>
>
> --
> Kind regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Bonnie" <bonnielynnw@discussions.microsoft.com> wrote in message
> news:6704AC7D-17C5-45B1-9673-805EA759218F@microsoft.com...
> > 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
>
>
>

[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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bonnie" <bonnielynnw@discussions.microsoft.com> wrote in message news:6704AC7D-17C5-45B1-9673-805EA759218F@microsoft.com...
> 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