can i move excel cells to word and still have the functions work?

Question

basically i have a table i want to transfer from excel to word.

can i do this though then add information to the table on word and still have the formula's in different columns work?

Answer 1

You can insert the excel table into word, then when in the word doc, double click on the table. It will open excel within word and the formulas will work.

Answer 2

You can copy and paste into Word which will automatically bring the data into table format. However, formulae and functions are best suited to Excel. Depending on what the formulae are though, if they are simple autosum, just click in the bottom row of each column, up to Table, Formula, and type in the formula =sum(above) or whatever formula you want. Note however, unlike Excel if you change the figures, the formula doesn't automatically update, but you would have to right click on the formula and select Update.



Alternatively, why not just copy and paste special as a link so that if you update figures in Excel it updates automatically in the Word document also.

Answer 3

Copy cells from Excel

Go to Word. Edit > Paste Special...

Choose Paste as "Microsoft Excel Object"

To edit the cells inside Word, double click on the Object. It will make small frame for Excel within Word.

Answer 4

Select and Copy the excel sheet

go to word

go to edit

select past sepcail

then select paste link

This will link the sheet from excel to that in word.

Any changes to the data in excel will be reflected in word.

If you don't see the updates taking place go to edit - then update link. good luck

Answer 5

I wuld have thought you would have to open a table in Word first and paste your Excel cells into that.

Answer 6

Yes.

Highlight the cells, copy and paste them into Word and then use them however you want.

2008 versions of Microsoft Office, I am not entirely sure about earlier versions, have a special toolbar for operating Excel cells.

Answer 7

i'm assuming which you're hiding focused rows. case in point, lets say that the numbers are entered in column A. In column B, enter a nil in cells wherein the row is hidden, a a million in cells wherein the row isn't hidden. In column C, enter the subsequent technique in each telephone: =IF(B__=a million,A__,"") The underline represents the present row quantity. case in point, sense you will be able to desire to have the quantity 7 in telephone A3. In telephone B3, enter 0 if row 3 is hidden, a million if row 3 isn't hidden. In telephone C3, you will be able to desire to have the physique of recommendations =IF(B3=a million,A3,""). So if row 3 is hidden, telephone C3 will incorporate a sparkling text textile value. If row 3 isn't hidden, telephone C3 will demonstrate 7. probably you were making use of the count form place to recollect what number cells were crammed in. so instead of growing to be use of the count form place for the cells in column A, use it to recollect the cells in column C. Any cells in column A which would be hidden could no longer be copied over to column C, and could no longer be included in the remember. this could could desire to paintings, in spite of the undeniable fact that the single flaw is for people who maximum usually difference which rows are hidden or now no longer hidden. you will be able to desire to have have been given to difference the cost in column B mutually as you hide or unhide a row.

Answer 8

just do as Otter said..

insert the table from Insert menue..