autofill name as you type?

[squirrellydw]

How can I have excel autofill names as I type them? Ideally what I would like is to have a list of employees and as I type their names in different columns it autofills them in. For example I start typing "Sta" and it gives me the names of everyone that starts with "Sta" and as I type more of the name the list gets shorter or autofills the name Stacy if that is the only name that matches. As a Bonus it would be nice if it would copy over any formatting, like colors to know how many males and females we have working.

thanks for any help

 

[RasGhul]

Hi Squirrel,

What version of excel do you have?

Can you post a sample of your names list?

 

[squirrellydw]

Hi Squirrel,

What version of excel do you have?

Can you post a sample of your names list?

Office 365

the spreadsheet just lists he day of the weeks across the top Sunday to Saturday, the dates under that then the name of the employees working each day.