9

Okay, I encountered a super weird thing. I haven't had the chance to try it on different machines, but when I type in "PartOf" within my header line of my Excel table, it automatically changes to "part of"! I tried using single quote prefix and it still changes (i.e. 'PartOf -> 'part of). Is this happening for you guys/gals too? Or is my computer insane?

I even tried copy and pasting from WordPad to make it work, but no, it changes it still. How can you type in "PartOf" within a cell?

4
  • 2
    Maybe it is spell checking?
    – Akina
    Dec 5, 2019 at 19:43
  • 1
    but I can confirm it does it on my version also Dec 5, 2019 at 19:44
  • Has to be spell checking, but how can I turn it off? :/
    – Isa
    Dec 5, 2019 at 19:48
  • 4
    Always turn off "autocorrect as I type" . It will invariably do more harm than good. Dec 6, 2019 at 14:50

2 Answers 2

20

You can turn it off or remove that specific change:

Go to Excel Options --> Proofing --> Auto correct Options.

Uncheck the Replace Text as you Type or find that specific line in the list and delete it.

enter image description here

0
21

Aside from switching it off permanently for all future, as described in the other answer:
if you want it only once not done, you can type CTRL+Z (undo) right after the change happens - this will undo the 'correction', not your typing.

2
  • While true, this is a very poor way to work, because your workflow & thought processes are being continually interrupted. Dec 6, 2019 at 14:51
  • 6
    Right - except if it is a one time case, and you know it. Normally, autocorrect does a useful job, but if a single time I need the uncorrected form, this is the right approach.
    – Aganju
    Dec 6, 2019 at 19:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .