Turning off and on (autocorrect)

[Rob]

I have to do a massive data entry project. I would be easier for me to use
numbers to correspond with survey results. For example: 1 = artistic, 2 =
creative, etc. I have about 100 choices AND about 2000 entries. Of course,
the autocomplete helps, but as the spreadsheet gets massive, it takes longer
for excel to recognize uniqueness.

Setting 'autocorrect' works great, but effects other spreadsheets that I
want to work on. I don't want to delete all the autocorrects that I built,
since this is an annual occurrence.

Can I 'turn off and on' autocorrect? and one step further ... If I know
that I only want autocorrect to only be in effect for a few columns within
my spreadsheet .. Is that possible?

I'm I better off simply using the numbers, then doing a 'replace all',
numbers with values? What do you think?

Thanks,

Robert

 

[Bernie Deitrick]

Rob,

If you have a list of possible values, say 100, insert 100 rows above your
entry fields and paste those values in those cells. Then you can use the
autocomplete (not autocorrect) to enter your values. This works well as long
as you have relatively unique strings. If you have

Creative Art Lesson 1
Creative Art Lesson 2
Creative Art Lesson 3

then it doesn't help as much. In the case above, you could change them to

C1 Creative Art Lesson 1
C2 Creative Art Lesson 2
C3 Creative Art Lesson 3

and do a replace on C1<Space>, etc. when you are done.

HTH,
Bernie
MS Excel MVP

 

[Peo Sjoblom]

You can use a macro that changes the autocorrect in a particular workbook
so that when you open the workbook it turns it off and when you close it
turns it back on

Private Sub Workbook_Open()
Application.AutoCorrect.ReplaceText = False
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.AutoCorrect.ReplaceText = True
End Sub


right click the excel icon next to the menu top left and select view code or
press alt + f11, double click ThisWorkbook