Clear Autofill List

  • Thread starter Thread starter Robert Pickett
  • Start date Start date
R

Robert Pickett

Hello,

How do I delete individual values or the entire autofill list? Thanks for
help.

Robert
 
Robert

Not sure what you're asking here.

Can you copy and paste a sample of your data and what you want done with it.

Autofill list is what? A list that you have entered into Tools>Options>Custom
Lists?

If so, just select in the dialog box and delete it.


Gord Dibben MS Excel MVP
 
Gord

Not sure I understand either but as another guess

Tools>Options>Edit>uncheck 'Enable autocomplete for cell values'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
Nick & Gord,

Nick & Gord,

Sorry for the imprecision with the original post. "Autocomplete" list would
have been more accurate.

Although Nick's solution prevents an autocompletion from the default
recently used list, the values are still shown on the Pick From List. Can
values be deleted from this list or the entire list cleared?

Thanks for your help.

Robert
 
Robert

The Pick From List items come from unique items in the column that is active at
the time of "picking"

You cannot get rid of them as far as I know, without deleting whatever is in the
column.

What is strange about the pick list is that row 1 is not included in the list.


Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ordinals 17
Day and Date Autofill 7
autofill won't fill to end of used range 3
autofill series 1
Autofill Increment a Reference to Another Worksheet 5
Autofill text boxes 1
Fill a spreadsheet automatically after one cell is input 1
Using Drop Down List to Autofill 2

Back
Top