auto complete stopped working when I tried to add a drop down list for editing values

[Tom21g]

hello all,

I'm running Excel from current version of Microsoft Office 365.
My pc is a Surface Pro 1 running Windows 10

Here's my problem: I have an excel spreadsheet to track my credit card charges.
Columns on this sheet are: charge, provider, transaction date, a code to categorize the charge (ex: "food", "gas", "takeout" etc)
I typically add a row and begin to enter data for a credit card charge.

It's the last column that started to fail. It always auto completed a code when I started to enter a category in the cell of the current row.

But I tried to add an editing tool to allow for a drop down list to select a code for that column.
On the same sheet I had a list of all the codes I would use. I attempted to make this list a table I guess to drive the drop down for this code column.

Well I couldn't get it to work and left it, but the result I think is that the code column has stopped auto complete for new cell values.

I removed the table property from the list of codes I had defined and converted it back to a simple range, but auto complete did not return.

I checked the advanced options and auto complete is still enabled.

It feels like there's a residual property on this code column that still wants to assign the table of codes as an editing tool, but I can't see it.

Does this sound right? Can anyone shed some light on this?

Thanks so much for your help
Tom

[Tom21g]

SOLVED

Went back to the spreadsheet and noticed that some of the data rows did not contain a category code in the last column.
It was empty.

When I filled in any empty cells, auto complete came back for new cells.

Now I know.

Regards
Tom

[AliGW]

I was just about to explain this to you! Thanks for telling us.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.