Using Autocomplete in Excel worksheet

0

I use an Excel worksheet to keep track of employee hours and the productivity they accomplish but on any given day, I have different employees who work with different people so each day I have to enter up to 20 different names and I would love to be able to just start typing a name and have it fill in automatically. Is that an option in Excel? Any way I can make this process quicker would be great.

Answer
Discuss

Answers

0

The easiest way to do this would be to crate a list of the names in a named range on a dedicated worksheet. Format the column where you need to enter the names with a Data Validation dropdown. Look at the implementaiton in the attached workbook.

The data validation dropdown doesn't have auto-complete. For that you would have to use an ActiveX ComboBox. That takes a lot more effort, however,. Try the simple data validation first.

Discuss
0

If you use this a lot, you might want to look into creating a UserForm for data entry; if you enter many pieces of similar information on a frequent basis, this will save you a lot of time.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login