ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel changes HDA to HAD (https://www.excelbanter.com/excel-worksheet-functions/188516-excel-changes-hda-had.html)

aimee209

Excel changes HDA to HAD
 
When I am in a spreadsheet, I have tried typing in HDA into a cell. When I
hit enter, it is automatically changed to HAD. I've even tried changing the
spell check to ignore words in capital letters, but it still changes. I've
also tried putting the ' before it, still changes. Please help

Thank you!

Dave Peterson

Excel changes HDA to HAD
 
In xl2003 menus:
Tools|Autocorrect options|Autocorrect tab

Remove the HDA entry.

Be aware that this autocorrect list is shared by other programs in the Office
suite.

aimee209 wrote:

When I am in a spreadsheet, I have tried typing in HDA into a cell. When I
hit enter, it is automatically changed to HAD. I've even tried changing the
spell check to ignore words in capital letters, but it still changes. I've
also tried putting the ' before it, still changes. Please help

Thank you!


--

Dave Peterson

JE McGimpsey

Excel changes HDA to HAD
 
If you don't want to change the autocorrect entry as Dave suggests, you
can always type CTRL-z to undo the autocorrect.

In article ,
aimee209 wrote:

When I am in a spreadsheet, I have tried typing in HDA into a cell. When I
hit enter, it is automatically changed to HAD. I've even tried changing the
spell check to ignore words in capital letters, but it still changes. I've
also tried putting the ' before it, still changes. Please help

Thank you!


PCLIVE

Excel changes HDA to HAD
 
This is part of the AutoCorrect Options.

Goto Tools | Options | Spelling (tab).
Click AutoCorrect Options (button)

You can scroll down the list and remove the "hda" line if you wish.

or, you could just check the box for "Ignore words in UPPERCASE".

HTH,
Paul

--

"aimee209" wrote in message
...
When I am in a spreadsheet, I have tried typing in HDA into a cell. When
I
hit enter, it is automatically changed to HAD. I've even tried changing
the
spell check to ignore words in capital letters, but it still changes.
I've
also tried putting the ' before it, still changes. Please help

Thank you!





All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com