Match Infomation

[Guest]

I want to format a whole column to match a list of co-workers, about 5-6,
initials who enter data on a particular worksheet. In other words an operator
would open this worksheet enter some information and begin to initial a cell,
this particular cell would automatically match information regarding
formatting (like all caps) and match it.
Q: What is the best way to do this?

 

[Mladen_Dj]

You can use Validation in this column. Select a column you want, go to
Data->Validation, and in dialog box "Allow:" select "list". In Source field
insert names of co-workers (Bob,Phill,Georg...) separated with comas. You
can also put list in range, and in sorce box insert this range. When
co-workers enters in list, they will need to select name for this column
from dropdown list, without any typing.

Another (easier) way...

Excel will, after few occasion when name was entered, give you autocomplete
option, same as you described. Be sure that in Tools->Options under Edit tab
was checked option "Enable AutoComplete for cell values".