Question

How can we duplicate data in Excel​

Answer 1

Answer:

first select the data and then press the shortcut key of copy

Answer 2

Explanation:

Step 1 select the cell you want to check for duplicate

step 2 click home<conditional forming<highlight cell rules < duplicate values

step 3 in the box next to value with ,pick the formatting you want to apply to the duplicate values,and then click OK