Forum Discussion
Excel Autocorrect Formatting
Is there a way to have Excel autocorrect the formatting of a word or phrase to italics? For example I'm trying to correct CAL to CALIFORNIA in italics. In Word, it's pretty straightforward, but there doesn't seem to be a way to do it in Excel.
I'd also accept any workarounds, for example if CAL autocorrected to CALIFORNIA, and then there was a way to automatically recognize CALIFORNIA and make it CALIFORNIA.
Any help would be greatly appreciated!
This doesn't exist in Excel since, unlike Word, text processing is not its primary purpose.
You might use VBA code. In the attached workbook, Sheet1 will replace some abbreviations and italicize the replacement matching the entire cell. Sheet2 will do the same for part of the cell.
You'll have to allow macros.
The code is in the worksheet modules - right-click a sheet tab and select View Code from the context menu to see and edit it.
8 Replies
- Hi Ryan. There are any number of ways depending on how you are doing it. Could you upload a workbook sample of what you are after ? Makes it easier to get the right answer for you... 🙂
- Hi Cambosity, thank for the quick response!
I can't upload anything really, confidential stuff. But it really is a very simple chart that I'm using as a board for a presentation. Participants will ask me to fill in the chart with various phrases, such as CALIFORNIA DREAMING or something similar. So I've created autocorrect shorthands such as CAL so I can better keep up with what they are saying. For some of the phrases, I want them to appear on the board in italics automatically.
In Word, you can easily just select the word in italics and create a shorthand for that, but the same functionality doesn't exist in Excel.This doesn't exist in Excel since, unlike Word, text processing is not its primary purpose.
You might use VBA code. In the attached workbook, Sheet1 will replace some abbreviations and italicize the replacement matching the entire cell. Sheet2 will do the same for part of the cell.
You'll have to allow macros.
The code is in the worksheet modules - right-click a sheet tab and select View Code from the context menu to see and edit it.
