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 😞
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...