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
Bookmarks