Feb 22 2021 07:48 AM
Feb 22 2021 09:15 AM
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 @Hans Vogelaar
Feb 22 2021 11:47 AM
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.
Feb 23 2021 12:50 AM
@Hans Vogelaar 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...