Forum Discussion
keep source formatting from word to excel
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
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.