Automatic corrections when using Microsoft Office Excel 2007

**skitmore** · 09-10-2009, 06:11 PM

Users need to be watch the screen carefully when entering data. If you enter, say, A* into one cell and then A into another cell, for the second entry Excel will change the A to A* with the * highlighted. If you just continue, Excel will replace the A with A* without warning. Therefore, entering data without looking at the screen can result in having the wrong data. Of course, you can turn off Excel's automatic correctionj facility (although I don't know how to do that yet). Would be better for Excel to default to what is actually typed though or at least ask permission to change data.

**oldchippy** · 09-10-2009, 06:17 PM

Hi,

You can turn it off under Excel Options > Advanced > Enable AutoComplete for cell values

**shg** · 09-10-2009, 06:21 PM

... but users should still pay attention, would you not agree, OC?

**oldchippy** · 09-10-2009, 06:23 PM

Originally Posted by shg

... but users should still pay attention, would you not agree, OC?

Sure do, but after using Excel this long you just get to use to it automatically

**skitmore** · 09-10-2009, 06:45 PM

Where can I find "Excel Options"?

**shg** · 09-10-2009, 07:02 PM

Office Button, at the upper left of the Excel window. Then look at the bottom of the window that opens.

**skitmore** · 09-10-2009, 07:14 PM

Thanks. Just found a whole lot of things I didn't know was going on! Call me old fashioned, but I really don't need any of these autocorrecting facilities. What I type is what I want!