Forum Discussion
keep source formatting from word to excel
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.
HansVogelaar yes, but the excel spell checker does not highlight or underline, so is very time consuming. It is quicker to do the spellchecking in word and paste in - even though that means re-doing all the formatting - hey ho....I don't think there is any better way round my problem...