How to Highlight Duplicates in 24 seconds 🤩 #excel

How to Highlight Duplicates in 24 seconds 🤩

Step 1. Select All (Ctrl + A).
Step 2. Go to the Home tab, Conditional formatting, Highlighy Cell Rules, Duplicates Values… (Alt + H + L + H + D).
Step 3. Choose Duplicate and change the fill/font color. Then press OK.

It's almost time...

Miss Excel is throwing a FREE Excel extravaganza THIS WEEK to help you save hours in your day by leveraging the power of Excel Dashboards to save you hours each week. Don't miss your chance to register! (link in our chanel page!).

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Видео How to Highlight Duplicates in 24 seconds 🤩 #excel канала CheatSheets