Autocomplete will do the job if entering data in the same column.

Sure sounds to me like you had some some type of event code running if all
you did was enter a letter and got input of information and color.


Gord Dibben MS Excel MVP

On Sat, 16 May 2009 22:53:01 -0700, Donna
wrote:

I am filling out excel spreadsheets with the same data, and instead of copy
and pasting I know there is a way you can set up excel so that you can just
press a key (say r) and it will automatically fill the cell with information,
and also you can have it a certain colour etc. I don't thinks it's a macro
as I've had this set up for me before and all you have to do is press a
single key. Help!