This guide was created with Scribe in 19 seconds. Sign in and create your own!
How to mark duplicates in Google Sheets
Created by Tiffany from Scribe | 14 steps
This Scribe shows you how to visibly mark duplicates in a single column in Google Sheets using conditional formatting. The same logic came be applied to multiple columns i.e. entire datasets
Navigate to your spreadsheet
Select the second cell in the column where you want to mark duplicates. If your column does not have a column header, select the first cell
Zoom Saved
Highlight the entire column of data: For PCs, press CTRL + SHIFT + DOWN. For Macs, press CMD + SHIFT + DOWN
Click "Format" and then "Conditional formatting"
Tiffany made this Scribe in 19 seconds.
Have something to say?Create an account to leave messages for the author to see!
Message sent!
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe