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

Show The Percent of Parent Column Total With Excel...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers suc...
Fix Incorrect Formatting Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically. Ever had the scenario where your data is formatted differently? Example: First names starting wit...
Excel Table: Styles There are lots of different Table Styles that you can choose from to spice up your Excel Table.  You can also customize your own style if you don't like any of the default Excel styles. To access the Table Styles, you simply need to click inside your Table and then the Table T...
Custom Date Formats in Excel Custom date formats in Excel allow you to display only certain parts of the date. Say you had a date of 18/02/1979, which coincides to be my birthday 🙂 You can use the Format Cells dialogue box to show only the number 18, the day that corresponds to that date (Sunday), the...