When you have a lot of data to review in an Excel file it can be tedious finding duplicate values. Today we will look at how to easily identify duplicate values with Conditional Formatting.
当您需要在Excel文件中查看大量数据时,查找重复的值可能很繁琐。 今天,我们将研究如何使用条件格式轻松识别重复值。
With the Excel document open highlight the section of the document to search for duplicate entries.
打开Excel文档后,突出显示文档部分以搜索重复的条目。
On The Ribbon click under the Home Tab is selected.
在功能区上,单击“主页”选项卡下的。
In the Styles section click on Conditional Formatting \ Highlight Cells Rules \ Duplicate Values.
在“样式”部分中,单击“条件格式” \“突出显示单元格规则” \“重复值”。
This opens up the Duplicate Values dialog box where you can select how to format the cells with duplicate data.
这将打开“重复值”对话框,您可以在其中选择如何使用重复数据格式化单元格。
Now you will be able to easily find the cells that contain the duplicate data so you can change the values or delete them.
现在,您将能够轻松找到包含重复数据的单元格,以便您可以更改值或删除它们。
This is a quick and easy tip to help make sure important spreadsheets contain correct information.
这是一个快速简便的技巧,可帮助确保重要的电子表格包含正确的信息。