#1
|
|||
|
|||
Excel Tables in Word, format issues
Hi all,
I seem to be having problems with an excel table in word. In my file, I have a Excel table inserted and when I input any data into it it looses its format and enlarges going off the page. I deleted the table and created a new table, thinking there might an issue with the table form excel, but no joy. The intial file was a .doc file and thought there might be issues with the type of file, so created a completley new one .docx. Same issue occured. I then had a look at all the options, but couldnt seem to locate anything. I finally reinstalled word and still no change. I using office 2010 on XP operating system. I would appreciatte any help, hopefully its a straight foward fix. Many Thanks, Kam |
#2
|
||||
|
||||
How have you inserted the Excel table?
I would suggest selecting the table in Excel, then use Paste Special > Bitmap and check the link check box. This will insert the table as a graphic that you can scale to fit the available space. Any changes you make in Excel will be reflected in the document and the size will not change. You will not be able to edit the table in Word.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
||||
|
||||
When you create an Excel object in a Word document, everything will be scaled to whatever size it would normally be in Excel. Consequently, you may need to adjust the inserted object's size by right-clicking on it and using Format>Object>Size to change the scaling. You can also adjust the embedded object's font sizes, column widths, row heights, etc. to get the sizing you require.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tables from Excel to Word: Problems | Guillo | Word | 0 | 11-19-2014 01:42 AM |
Excel to Word and delete certain tables | jon12355 | Word VBA | 10 | 10-15-2014 03:01 PM |
Issues with Excel tables in Word | QuasidodoJr | Word | 1 | 04-24-2012 04:18 PM |
how to copy all ms word tables into excel | rehan129 | Word | 0 | 01-28-2012 10:17 AM |
Excel Tables to MS Word | ripcurlksm | Word Tables | 2 | 09-09-2011 04:59 AM |