ExcelBanter - Can you enable auto complete from a custom list in Excel?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can you enable auto complete from a custom list in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/18165-can-you-enable-auto-complete-custom-list-excel.html)

poaq

Can you enable auto complete from a custom list in Excel?

Gord Dibben

No.

Autocomplete or "Pick from list" gets its information from cells above and
below the point in the same column that you are entering new data.

A custom list entered in ToolsOptionsCustom Lists is used for autofilling
and when sorting.

Gord Dibben Excel MVP

On Thu, 17 Mar 2005 13:27:01 -0800, "poaq"
wrote:

All times are GMT +1. The time now is 04:55 PM.