Autocorrect text while typing in a cell?

[Ironman]

Hi

I'm not sure how Autocorrecting text is supposed to work in Excel, but it isn't working for me when I'm typing text within a cell, despite all the boxes in the appropriate Autocorrect tab being checked.

I just need typos to be highlighted and/or corrected as I type text within a cell.

Is this possible and if so, how?

Many thanks!

 

[6StringJazzer]

Excel does not do spellcheck as you type, like Word does. You have to click on Review > Spelling to run spellcheck.

Autocorrect does not show or fix typos. It scans for certain strings that are set up in the Autocorrect list and automatically changes them to the target string. The list is preloaded with common symbols and typos. For example

(c) → ©
teh → the
aboutthe → about the

and so on. But they have to explicitly in this list to be corrected.

 

[Ironman]

Thanks Jeff. I was wondering if there might be a VBA solution that could highlight typos or something similar.

 

[6StringJazzer]

The issue with VBA is that VBA won't run when a cell is open for editing. VBA can't work on a cell as you type, only after you hit "Enter".

You can use VBA to check spelling each time a cell is completed:

Private Sub Worksheet_Change(ByVal Target As Range)

   Target.CheckSpelling

End Sub

 

[Ironman]

Thanks again Jeff, yes, that's the nub of the issue - and being a sheet change event, it'll interfere with other stuff happening within the same event as well as re-check everything in the sheet.

 

[Michael M]

@Ironman If it is a list of names for instance..you can put the list of names above the header row then hide them, then when you start typing a name further down in the same column, it will autofill...otherwise I think you will need to correct your typos manually !!

 

[Ironman]

@Michael M That's certainly an interesting solution Michael, many thanks for that.