Computer Science, asked by kalpana1022, 6 months ago

Write the steps to duplicate data​

Answers

Answered by princesspinki
1

Answer:

Finding the duplicate data is quite simple in Excel. You do not require writing any formula but following a few mouse clicks in the menu/Toolbar.

In this tutorial, I will show you step by step of how to find the duplicate data in rows/columns in different ways. This is followed by steps for deleting the duplicate data.

The Headlines hide

1. Step 1 – Find the duplicate data

2. Step 2 – Locate the Conditional Formatting Button

3. Step 3 – Find Duplicate Values option

4. Step 4 – finding the duplicates

5. How to remove duplicate data in Excel Sheets?

5.1. Step1 – Selecting the data

5.2. Step 2

6. Highlight duplicates only for the specific value

7. Another quick way of highlighting the filtered duplicate values

8. How to count the duplicates?

Explanation:

I hope it's help you ☺☺dearest

Similar questions