Open the Excel workbook
Go to the worksheet tab (bottom)
Right-click the sheet tab
Select Unprotect Sheet
Enter the password (if prompted)
Click OK
If the sheet is protected at...
Select the cell(s) in the row you want locked.
Right-click the selected cell(s) and choose Format Cells.
Go to the Protection tab.
Uncheck Locked.
Click OK.
Select the row(s)...
Select the cells or range you want to lock
Press Ctrl + 1
Go to the Protection tab
Check “Locked”
Click OK
Select the entire worksheet (press Ctrl +...
Select the cell(s) where you want the drop-down list to appear.
Go to the **Data** tab.
Click **Data Validation**.
In **Allow**, choose **List**.
In **Source**, do one of...
Select the cells you want to merge.
Go to the Home tab.
In the Alignment group, click Merge & Center.
Choose one option:
Merge & Center
Merge Across
Merge Cells
Unmerge...
Select the range of cells to check for duplicates
Go to Home tab
Click Conditional Formatting
Click Highlight Cells Rules
Click Duplicate Values
Choose a formatting style
Click OK
Select the range (or entire column) to check for duplicates
Go to Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values
Choose a formatting...
Select the range or column to remove duplicates from
Go to the Data tab
Click Remove Duplicates
If needed, check/uncheck the columns to evaluate
Click OK
Review the “Duplicates...
Select the cell or range where you want the drop-down list.
Go to the ribbon and click the **Data** tab.
Click **Data Validation**.
In the **Settings** tab,...
