|
Need to print formulas
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 |
Hi Bonnie,
CTRL` -- Kind regards, Niek Otten Microsoft MVP - Excel "Bonnie" wrote in message ... 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 |
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 |
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 |
Thx.
-- Bonnie "Niek Otten" wrote: Hi Bonnie, CTRL` -- Kind regards, Niek Otten Microsoft MVP - Excel "Bonnie" wrote in message ... 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 |
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" wrote in message ... 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 |
| All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com