You can automate the task of inserting red circles around items using Data Validation tools.

Create data validation for accuracy You can also use data validation to ensure data accuracy by restricting input to specific types, values, or ranges.

In the Status column, I want to create a drop-down menu to add the current status for each task quickly. I will use Excel’s data validation to get the job done. Here’s how.

To create a drop-down list in Excel, you will use the Data Validation feature. This feature enables you to set specific criteria for the data that can be entered into a cell.

If you regularly deal with enormous data sets in Excel, knowing how to use these features (some simple, others intricate) can help you manage your workload.

1] Use Excel Filter to find differences Using the Filter function is one of the easiest methods to find out discrepancies in data, especially for Excel sheets with large data and spelling errors.

Inserting Drop-Down Lists with Data Validation Once you have created named ranges for your lists, the next step is to insert the drop-down lists using Excel’s data validation feature.