ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Temporarily Disable Autocorrect (https://www.excelbanter.com/excel-discussion-misc-queries/129612-temporarily-disable-autocorrect.html)

Sloth

Temporarily Disable Autocorrect
 
I am trying to enter 'i' in a cell without it changing to I. I know you can
disable the autocorrect functions, but is there a quicker way to do this? In
word you can just "undo" the autocorrect and go on. The end result is that
the autocorrect continues to function but skipped that one instance.

john the confused

Temporarily Disable Autocorrect
 
I thought you could use the undo on the toolbar or click Ctrl+z after it had
made the correction to revert it back to how it was typed
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Sloth" wrote:

I am trying to enter 'i' in a cell without it changing to I. I know you can
disable the autocorrect functions, but is there a quicker way to do this? In
word you can just "undo" the autocorrect and go on. The end result is that
the autocorrect continues to function but skipped that one instance.


Dave F

Temporarily Disable Autocorrect
 
Yes, ctrl+z does that in Excel. I just tested it.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"john the confused" wrote:

I thought you could use the undo on the toolbar or click Ctrl+z after it had
made the correction to revert it back to how it was typed
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Sloth" wrote:

I am trying to enter 'i' in a cell without it changing to I. I know you can
disable the autocorrect functions, but is there a quicker way to do this? In
word you can just "undo" the autocorrect and go on. The end result is that
the autocorrect continues to function but skipped that one instance.


Sloth

Temporarily Disable Autocorrect
 
the undo doesn't work the same way for me. I can "sometimes" hit i [space]
and then undo (won't work for multiple cells in a row). But it never works
with just i [enter] (undo clears the cell).

This is using Excel 2000. I don't know if it's been fixed in newer versions.

"john the confused" wrote:

I thought you could use the undo on the toolbar or click Ctrl+z after it had
made the correction to revert it back to how it was typed
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Sloth" wrote:

I am trying to enter 'i' in a cell without it changing to I. I know you can
disable the autocorrect functions, but is there a quicker way to do this? In
word you can just "undo" the autocorrect and go on. The end result is that
the autocorrect continues to function but skipped that one instance.


john the confused

Temporarily Disable Autocorrect
 
Could be - I was using 2003.

I have just tried it on 2000 and Ctrl+z works as long as the cells are not
consecutive.
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Sloth" wrote:

the undo doesn't work the same way for me. I can "sometimes" hit i [space]
and then undo (won't work for multiple cells in a row). But it never works
with just i [enter] (undo clears the cell).

This is using Excel 2000. I don't know if it's been fixed in newer versions.

"john the confused" wrote:

I thought you could use the undo on the toolbar or click Ctrl+z after it had
made the correction to revert it back to how it was typed
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Sloth" wrote:

I am trying to enter 'i' in a cell without it changing to I. I know you can
disable the autocorrect functions, but is there a quicker way to do this? In
word you can just "undo" the autocorrect and go on. The end result is that
the autocorrect continues to function but skipped that one instance.


john the confused

Temporarily Disable Autocorrect
 
I was always putting in a space and then Ctrl+z. i on its own does not work.

Have you considered adding 'ii' to auto correct and changing it to 'i' as a
workround?

--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"john the confused" wrote:

Could be - I was using 2003.

I have just tried it on 2000 and Ctrl+z works as long as the cells are not
consecutive.
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Sloth" wrote:

the undo doesn't work the same way for me. I can "sometimes" hit i [space]
and then undo (won't work for multiple cells in a row). But it never works
with just i [enter] (undo clears the cell).

This is using Excel 2000. I don't know if it's been fixed in newer versions.

"john the confused" wrote:

I thought you could use the undo on the toolbar or click Ctrl+z after it had
made the correction to revert it back to how it was typed
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Sloth" wrote:

I am trying to enter 'i' in a cell without it changing to I. I know you can
disable the autocorrect functions, but is there a quicker way to do this? In
word you can just "undo" the autocorrect and go on. The end result is that
the autocorrect continues to function but skipped that one instance.



All times are GMT +1. The time now is 04:17 AM.

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