Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Data Validation

Resolved · Low Priority · Version 2007

Reply Fri 11 Nov 2011, 16:44Delegate Paul said...

Paul has attended:
Excel Advanced course

Data Validation

When I have a drop down list on a data validation, how can I get excel to autofill the rest of the list? Eg as I type Joh.. it brings my options to joh

For upcoming training course dates see: Pricing & availability

Reply Fri 18 Nov 2011, 12:33Trainer Simon said...

RE: Data Validation

Hi Paul,

Thank you for your question and welcome to the forum.

The only way I can see of doing it is using a combo box and set the properties for autocomplete.

Please find the link below that hopefully will help you.

http://www.contextures.com/xlDataVal11.html

Have a good weekend.

Regards

Simon

Thu 24 Nov 2011: Automatically marked as resolved.

Excel articles

· Use Hyperlinks In Excel To Make An Impact
· From novice to expert users - Microsoft Excel fits all
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Which Is Better, Excel Or Access?
· Excel Offers A More Relaxing Way To Work Out

Please browse our web site to find out more about
excel vba training course london and other Microsoft training courses.

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips