Maximizing Connectivity & Productivity

Excel – Draw circles around invalid entries

Once you have set your validation rules, use the circle feature in Excel to circle the invalid entries.  This is an oft forgotten useful tool that is simple to use and apply.

To use, highlight the column containing the validation rule(s).  Goto Data-> Data Tools-> Data Validation dropdown, select Circle Invalid Data.

To remove the circles, goto Data-> Data Tools-> Data Validation-> Clear Validation Circles.

Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500