keep source formatting from word to excel

Question

Please someone tell me how to keep the source formatting when pasting from word to excel!!! It's driving me mad and generating a lot of extra work 😞

hansvogelaar · Answer

JANETBIGGAR 
In Excel, click the lower half of the Paste button on the home tab of the ribbon, and select the first option: Keep Source Formatting.
&nbsp;

janetbiggar · Answer

yes, but that is greyed out when pasting more than one line of test - sorry should've been clearer...HansVogelaar&nbsp;

hansvogelaar · Answer

JANETBIGGAR&nbsp;
Are you trying to paste multiple lines/paragraphs into a range, or into a single cell?

janetbiggar · Answer

into a single cell - It seems it isn't possible to do that without losing formatting - another solution would be if I could get excel to check spelling as I type - that's the reason I'm pasting in from word in the first place&nbsp;HansVogelaar&nbsp;

hansvogelaar · Answer

JANETBIGGAR&nbsp;
As you have found, it is not possible to preserve formatting when you start editing a cell and then paste text into it.
Excel does not provide "live" spell-checking, but you can press F7 to spell-check a range of cells.

Forum Discussion

keep source formatting from word to excel

6 Replies

Resources