Home >Software Tutorial >Office Software >How to add a data identification circle in Excel_How to add a data identification circle in Excel

How to add a data identification circle in Excel_How to add a data identification circle in Excel

WBOY
WBOYforward
2024-04-25 17:34:141175browse

Want to easily tag data in an Excel sheet to quickly identify and find specific information? PHP editor Apple brings you a detailed tutorial to teach you how to use data identification circles to easily implement data labeling and improve work efficiency. Continue reading the following content to learn the detailed steps of adding data identification circles in Excel, say goodbye to data clutter, and improve report visualization.

First open an Excel table. We found that the table contains the scores of each subject of Class 1 of the third grade. Here we need to find the scores greater than 110 points:

How to add a data identification circle in Excel_How to add a data identification circle in Excel

Select all For cells containing scores, click [Data] on the toolbar, select [Validity] in the drop-down menu, or select [Validity] in the secondary menu:

How to add a data identification circle in Excel_How to add a data identification circle in Excel

In the pop-up In the data validity dialog box, [integer] is allowed to be entered in one column, select [less than or equal to] for the data list, select [110] for the maximum value, click OK:

How to add a data identification circle in Excel_How to add a data identification circle in Excel

and then click again [ [Validity] under the Data] option, and then select [Circle Invalid Data] in the secondary menu:

How to add a data identification circle in Excel_How to add a data identification circle in Excel

At this time, all data greater than 110 are marked:

How to add a data identification circle in Excel_How to add a data identification circle in Excel

The above is the detailed content of How to add a data identification circle in Excel_How to add a data identification circle in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete