Data Validation

Resolved · Low Priority · Version 2007

Fri 11 Nov 2011, 16:44 Delegate 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

Fri 18 Nov 2011, 12:33 Trainer 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 tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips

Data Validation

Data Validation

RE: Data Validation

Excel articles

Excel tip:

Conditional Formatting in Excel 2010