control autocorrect

  • Thread starter Thread starter Will Fleenor
  • Start date Start date
W

Will Fleenor

I have lost of AutoCorrect shortcuts in Excel 2003. On ocassion I will type
in an autocorrect shortcut and no want the autocorrect to occur. In Word
all you have to do is press the Undo icon and the entry reverts back to the
un-autocorrected entry. When you do this in Excel it simply removes the
entry altogether.

Question: Is there any way to enter an item that is on the autocorrect list
and not have the autocorrect work short of turning off autocorrect before
entering the item?

Thanks, Will
 
I have a solution to undoing autocorrect in Excel.

1. Before typing anything into the cell press the F2 Edit key.

2. Type the entry and press the spacebar (the autocorrect will work but
do not worry just continue)

3. Click on the undo icon

4. Press enter

Because autocomplete takes precedent over autocorrect you can continue to
type the same entry in that column only and will not have to fight with the
autocorrect.

In word a simple click of the Undo icon will undo and autocorrect.

Will Fleenor
 
After you enter the shortcut, hit the <Space> bar.
You'll see the change.
Just hit <Ctrl> <Z>, and continue typing the rest of your data, or hit
<Enter> if you're finished with the cell.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have lost of AutoCorrect shortcuts in Excel 2003. On ocassion I will type
in an autocorrect shortcut and no want the autocorrect to occur. In Word
all you have to do is press the Undo icon and the entry reverts back to the
un-autocorrected entry. When you do this in Excel it simply removes the
entry altogether.

Question: Is there any way to enter an item that is on the autocorrect list
and not have the autocorrect work short of turning off autocorrect before
entering the item?

Thanks, Will
 
Back
Top