Search code examples
excelms-office

Addition of multiple autocorrect substitution words to excel in one shot?

On my home PC, I have MS Office 2007. I use excel regularly and have a large number of autocorrect substitution words added to the language list. Is there some way I can import that list into another the MS Office for my office, which is a different PC? Is there some import/export option for this?

Solution

  • Try going to Excel File => Options => Proofing=>Custom Dictionaries. You can add additional dictionaries there.

    Tried to find some non VBA solution but it seems like there isn't one. what you could try is to put all your autocorrect words in Sheet1, Column A containing word to correct, and column B containing corrected word. then try this code

    Sub AddAutocorect()
For x = 1 To Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
Application.AutoCorrect.AddReplacement Range("A" & x).Value, Range("B" & x).Value
Next x
End Sub

    This code should add all autocorect values without the need for manual data entry.