|
|
#1
09-01-2014, 08:50 PM
|
|||
|
|||
pasting from excel to word maintaining word formatting
Trying to paste from Excel to Word but maintain the formatting within the table already in Word.
The tables in Word have specific text and number formatting (totals are bolded and coloured using the style functionality in Word) and no matter which paste option I select, even keep text only, it overwrites the style set and pastes the text from excel in as Normal text style. Help! 
|
|
#2
09-01-2014, 10:51 PM
|
||||
|
||||
|
Try Paste Special > HTML. It won't retain the cell sizes, but the formatting should be the same.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com
|
|
#3
09-01-2014, 10:56 PM
|
||||
|
||||
|
Unless you paste on a cell-by-cell basis, you can't avoid overwriting the destination formatting unless everything in the destination is in a single format.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? | GracieB | Word | 7 | 10-02-2013 06:24 AM |
| Maintaining word format when linking text from excel | MikeFee | Office | 0 | 06-11-2013 05:03 PM |
| copying and pasting Excel tables into Word | derohanes | Word | 1 | 01-24-2013 12:07 AM |
| Pasting linked Excel pie charts into Word | Paul-NYS | Office | 0 | 07-01-2011 06:56 AM |
 Maintain formatting while copying text from word, and pasting into a webpage.
|
kdogg121 | Word | 1 | 07-07-2009 02:50 AM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
