1. Write steps to Protect a Worksheet
2. Write steps to remove duplicates in Ms Excel.
Answers
Answered by
1
Answer:
Follow these steps:
Select the range of cells, or ensure that the active cell is in a table.
On the Data tab, click Remove Duplicates (in the Data Tools group).
Do one or more of the following: ...
Click OK, and a message will appear to indicate how many duplicate values were removed, or how many unique values remain.
Answered by
0
Answer:
Remove duplicate values
Select the range of cells, or ensure that the active cell is in a table.
On the Data tab, click Remove Duplicates .
In the Remove Duplicates dialog box, unselect any columns where you don't want to remove duplicate values. ...
Click OK, and a message will appear to indicate how many duplicate values were removed.
Similar questions