Haw to delete or edit Customize List in Option window in Excel

  • Thread starter Thread starter Girina
  • Start date Start date
G

Girina

I have a problem with Customize List in Excel. I want to delete or edit
Customize List in Option window in Excel. But the Delete button is not
visible. At attempt to write down number in a cell, the number is
automatically translated in a format of date.

Irina Gogelia
Georgia.Tbilisi.
 
Some of the custom lists are default Excel lists and cannot be deleted.

i.e. weekdays and months are default.

What type of number are you entering?

Data like 1-2 are interpreted as dates by Excel.

Preface with an apostrophe to enter this type of data.


Gord Dibben MS Excel MVP
 
I have a problem with Customize List in Excel. I want to delete or edit
Customize List in Option window in Excel. But the Delete button is not
visible. At attempt to write down number in a cell, the number is
automatically translated in a format of date.

Irina Gogelia
Georgia.Tbilisi.
Click to expand...

That sounds more like a format problem. Change the cell's format to
General or a number format.

Custom Lists will only affect you if you are making a list in your
data. And you can't delete the built-in lists, only those you have
created.
 
Back
Top