Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation (list) & auto fill
I have a list of several hundred names which I linked to a column of cells
using validation. Is there a way to begin typing a name and have auto fill search alphabetically making the section process quicker and easier? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation (list) & auto fill
I have a list of several hundred names which I linked to a column of cells
using validation Does that mean it's a data validation drop down list? You can use a combo box from the control toolbox. This type of combo box has an "autocomplete" feature. -- Biff Microsoft Excel MVP "Charlie7805" wrote in message ... I have a list of several hundred names which I linked to a column of cells using validation. Is there a way to begin typing a name and have auto fill search alphabetically making the section process quicker and easier? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation (list) & auto fill
That's not possible in a standard data validation list. You can use a
combo box instead, as described he http://www.contextures.com/xlDataVal11.html Or add letters in the source list, as shown in Roger Govier's sample file he http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0046 - Add Headings for Navigation' Charlie7805 wrote: I have a list of several hundred names which I linked to a column of cells using validation. Is there a way to begin typing a name and have auto fill search alphabetically making the section process quicker and easier? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill/list | Excel Discussion (Misc queries) | |||
Drop Down List & Auto Fill | New Users to Excel | |||
Auto Fill from Drop Down list | Excel Worksheet Functions | |||
Can Validation against a list do auto-fill in a cell? | Excel Discussion (Misc queries) | |||
Auto-Fill in List Fields? | Excel Worksheet Functions |