Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I created a dropdown list with values and assigned them to one of the columns in a table.

When I changed a few, then changed the name of items in the list and removed some I accidentally did some key combination somewhere around Ctrl+Z or Ctrl+Y and Excel highlighted cells in the table that had a value not on the list.

The highlighting looks like a red oval around each such cell. How can I toggle it on and off?

share|improve this question

In the ribbon, you might see an entry like this around data validation. Clear Validation Circles

Check out this article from microsoft for more information.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .