The table I have in word is very wordy and large. Excel doesn't appear to support it. There are 8 columns and a large amount of rows.
2006-10-11 04:13:35 · 3 answers · asked by Miriam M 1 in Computers & Internet ➔ Other - Computers
I think you should first try copying and pasting it directly in to excel. I am sure you must have done it before? if so then try this way.
At the edge of the MSword table cell go over and find a crossedmark. Click it and cut the whole table ( till it disappear from word), then paste it into excel doc
If still can't fix it just IM me agfa98@yahoo.com I will help u out
2006-10-11 04:26:16 · answer #1 · answered by Ozone3 3 · 1⤊ 0⤋
Merge the Excel cells where you will put the Word table. You will now have one large cell. Then, copy the Word table and paste into the merged Excel cells.
2006-10-11 11:25:53 · answer #2 · answered by farahwonderland2005 5 · 0⤊ 0⤋
Excel supports up to 65,536 rows. If you have more than that, is using MS Access an option? You might have better luck with that. Otherwise, splitting the data into multiple sheets might be your only option. Then you'll have to do calculations on both if you want to use the data for any calculations, reporting or pivot tables.
2006-10-11 11:38:36 · answer #3 · answered by SDLifeCycle 2 · 1⤊ 0⤋