ExcelBanter - excel 2002 question for pick from list with autocomplete function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel 2002 question for pick from list with autocomplete function (https://www.excelbanter.com/excel-worksheet-functions/180408-excel-2002-question-pick-list-autocomplete-function.html)

Morris

excel 2002 question for pick from list with autocomplete function

enter data in a cell from a list you specify with auto complete function

Gord Dibben

excel 2002 question for pick from list with autocomplete function

"Pick from list" only provides a list of unique contiguous items in a column.

Autocomplete also works only with contiguous data in a column.

Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 00:14:00 -0700, Morris
wrote:

enter data in a cell from a list you specify with auto complete function

All times are GMT +1. The time now is 05:19 AM.