How to Quickly Highlight Blank Cells in Excel

In this video, you will learn how to quickly highlight blank cells in Excel using two methods - conditional formatting and Go To Special.

When I get a data file from a client/colleague or I download it from a database, I do some basic checks on the data. I do this to make sure there are no missing data points, errors or duplicates that may lead to issues later.

One such check is to find and highlight blank cells in Excel.

There are many reasons that can result in blank cells in a dataset:
-- The data is not available.
-- Data points accidently got deleted.
-- A formula returns an empty string resulting in a blank cell.

While it’s easy to spot these blank cells in a small dataset, if you have a huge one with hundreds of rows and columns, doing this manually would be highly inefficient and error prone.

Read More: trumpexcel.com/highlight-blank-cells-in-excel/




Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial