Forum Discussion
keep source formatting from word to excel
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 😞
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.
 
yes, but that is greyed out when pasting more than one line of test - sorry should've been clearer...HansVogelaar
Are you trying to paste multiple lines/paragraphs into a range, or into a single cell?
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 HansVogelaar
