Pinterest Pixel

Find Blank Cells In Excel With A Color

In Excel you can have a data set that comes from an external source which isn’t always... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

In Excel you can have a data set that comes from an external source which isn’t always formatted to your liking.

One of the most common things you may encounter are blank cells in your Excel data which can hinder your analysis, especially if you are using a Pivot Table to analyze the data.

To find these annoying blank cells in Excel you will need to highlight all your data set (CTRL+*) and bring up the Go To shortcutCTRL+G > Special > Blanks.

Then you can fill in the blank cells with a color red and filter by that same color to drill down to these blank cells and take some formatting action.

I show you how easy this can be done below.

Find Blank Cells In Excel With A Color | MyExcelOnline

download excel workbook Go-To-Blanks-By-Color.xlsx

STEP 1: Make sure your entire table is selected. We will select all the blank cells.

Find Blank Cells In Excel With A Color

STEP 2: Press Ctrl + G to open the Go To Window. Click Special.

Find Blank Cells In Excel With A Color

Select Blanks. Click OK.

See also  Drop Down Menu In Your Excel Table

Find Blank Cells In Excel With A Color

 

STEP 3: The blank cells are now selected. Go to Home > Font > Fill > Color Red

Find Blank Cells In Excel With A Color

 

STEP 4: Let us try it out! Try filtering the Customer column by selecting Filter by Color > Color Red

Find Blank Cells In Excel With A Color

Our filtering has worked to show the blank cells!

Find Blank Cells In Excel With A Color

How to Find Blank Cells In Excel With A Color

 

HELPFUL RESOURCE:

Resize All Charts Using Macros In Excel

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!