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 shortcut:  CTRL+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.

DOWNLOAD EXCEL WORKBOOK

 

Go To Blanks - By Color

HELPFUL RESOURCE:

eu_logo_150

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

Share on Google+

Google+

Related Posts

Excel´s Fill Justify Tool An interesting tool within Excel is the Fill Justify.  It allows you to select text from several rows and merge them in to one cell. So if you have data that gets downloaded in to separate rows and want to join them up in to one sentence, then the Excel´s Fill Justify option i...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count. Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...
Split First & Last Name Using Text to Columns There are times when you receive a data set of employee full names in one column and you want to separate the full name into first name and surname in separate columns. One way is to use the Power Query method, which is great if you have lots of data that gets added each day, ...
Quick Access Toolbar The Quick Access Toolbar (QAT) is located at the top left hand corner of the ribbon and has the most commonly used commands, like the Save, Undo and Redo.  The QAT is unique to each user´s workbook settings. You can move the QAT below or above the ribbon by right clicking on t...