Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to import an excell table into a word doc. Is there a way to do
this and keep the formulas??? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Are you pasting the excel data or using paste link? If you paste link the
object as Excel, you will keep the original formulas and data. Or are you trying to simply bring over the formulas and use them in a word table? I need a little more explanation..... "Sarah" wrote: I am trying to import an excell table into a word doc. Is there a way to do this and keep the formulas??? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am making an Invoice for our business. I made just the basic excel table
with formulas to add certain columns. Just basic Information. When I copied and pasted the it table into word none of the formulas went with it and there doesn't seem to be a way to enter them in once it is in Word. Do you get what I mean? It is really hard to explain this lol "Jean-Toledo" wrote: Are you pasting the excel data or using paste link? If you paste link the object as Excel, you will keep the original formulas and data. Or are you trying to simply bring over the formulas and use them in a word table? I need a little more explanation..... "Sarah" wrote: I am trying to import an excell table into a word doc. Is there a way to do this and keep the formulas??? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes can copy the Cell range and use Paste Special and clickaste link in
Microsoft Word. If you have very simple formulas then you can follow this procedu If you use mathematical function, you have to view Word tables similar to Microsoft Excel speadsheet. For example, The column headings of Excel is A,B,C and so on, will have to considered the simlar way when you work in Word Table. And the way you refernce the cells in Excel will be the same in Word too. Assuming that you have three columns, and you want the product of column 1 and two in column three. you will enter the fomula this way: 1. Place the insertion point in Column three. 2. Press Ctrl+9 to create the braces{}. 3. Enter the formula inside the brace by preceding with the symbol "=" The formula you enter should like this {=A1*B1}. You can brackets to specify the order of caluclation. 4. Press F9 to recalculate the product details to display the current value. Challa Prabhu "Sarah" wrote: I am trying to import an excell table into a word doc. Is there a way to do this and keep the formulas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export from Excell to Word | Excel Discussion (Misc queries) | |||
Can you convert a excell sheet to a word document | Excel Worksheet Functions | |||
how do i move from excell to word for better readable subject | Excel Discussion (Misc queries) | |||
Linking Excell values to word document | Links and Linking in Excel | |||
S.O.S :importing excell data into word | Excel Discussion (Misc queries) |