#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 231
Default Word and Excell

I am trying to import an excell table into a word doc. Is there a way to do
this and keep the formulas???
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Word and Excell

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 231
Default Word and Excell

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default Word and Excell

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export from Excell to Word Fts Excel Discussion (Misc queries) 1 October 18th 06 10:42 PM
Can you convert a excell sheet to a word document GTIphil Excel Worksheet Functions 1 May 18th 06 10:51 PM
how do i move from excell to word for better readable subject Clovis Excel Discussion (Misc queries) 1 April 7th 06 08:34 PM
Linking Excell values to word document Kent Links and Linking in Excel 0 January 17th 06 08:56 PM
S.O.S :importing excell data into word villi Excel Discussion (Misc queries) 0 November 25th 04 08:37 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"