Say you have a data set and want to make sure that each column contains what it is supposed to.

For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text.

You can easily check this by highlighting that column and pressing CTRL+G to bring up the Go To dialogue box (or by choosing from the menu Home > Find & Select > Go To…)

Then you need to choose Special > Constants and select the constant that you want to find in your column.

In our example you will need to only select the Text box and de-select the other boxes and press OK.  This will highlight the cells that contain text and you can begin to format these cells.

See how this is done by watching the gif tutorial below.

DOWNLOAD WORKBOOK

Go To Constants

HELPFUL RESOURCE:

728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Add Custom Symbols With Your Numbers in Excel A cool feature within Excel is the ability to format a cell's value by pressing CTRL + 1 on any cell.This brings up the Format Cells dialogue box and under the Custom category you can customize the Type to whatever you like and even insert symbols!There are four formattin...
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, ...
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...
Drop Down Menu In Your Excel Table Apart from creating a simple Drop Down Menu/List or Data Validation List, you can expand this concept to include it in your Excel Table or Database.Watch how to insert a Data Validation ListThat way you don't have to do repetitive tasks like entering the same customer ov...