One possibility is to setup some AutoCorrect settings that will convert to
the desired results. The only hard part about it is finding unique key
combinations that are easily remembered to represent the desired codes.

For example:

Type the tilde character (~) and it automatically changes to CTUM-NV.

This can be very useful when you want to autocorrect long repetitive
strings. I don't think you really gain anything setting an autocorrect for a
2 character string like RF or RC.

--
Biff
Microsoft Excel MVP


"Bailey9399" wrote in message
...
I need to input the entries in one column - ex: RF , RWW, RC, CTUM-NV,
It depends on the disposition on what code goes into that cell. But, they
are the same ones all the time. Is there a way to set-up a shortcut keys
for
these.

I do not want to use drop down boxes because this is a huge spreadsheet.

We do not have Access, which that would of been my choice.

Any help would be greatly appreciated.