How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 2108
Experience:  20 years experience providing remote computer support
62934938
Type Your Computer Question Here...
The-PC-Guy is online now

I would like to load a preset of names in to excel, eg, if

This answer was rated:

Hi i would like to load a preset of names in to excel,
eg, if im typing Ronald donald, that when im typing it picks it from a list

Hello,

You can set up data validation to select preset names from a list.

Is that what you mean?

Customer: replied 1 month ago.
It s not really what i mean,
basically, if i type mcdonalds in cell a1,and then type mc in cell a2, it will show me the option of mcdonalds as its predicting what I'm typing, but i would like to select any cell on the sheet or workbook and have it try to predict what I'm typing.
regards luigi

Ok, let me check with the other experts on this...

it is not possible for you to have excel do this. WHat you want to do is type "george" in the first row, "grange", then type "g" in the 3rd rwow and have it determine you want one of the previous g names. But this is only possible on a per column Basis, like if you have all the names in column Q then this will only work in column Q and will only work for previous typed names in the same column

The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 2108
Experience: 20 years experience providing remote computer support
The-PC-Guy and 3 other Computer Specialists are ready to help you