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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Number Formats – Thousands & Mill... Large numbers in Excel can be formatted so they can be shown in "Thousands" or "Millions". By using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions. You can even add som...
Find & Replace The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below. DOWNLOAD WORKBO...
Rank Largest to Smallest With Excel Pivot Tables 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 RANK LARGEST TO SMALLEST calculation. This option will immediately calculate the rankings (1 being the LARGEST value) for your values, allowing you to pi...
How To Make Negative Red Numbers In Excel When you are working with lots of different numbers in Excel, you sometimes want your numbers to stand out by showing them in a negative red number with a minus sign in the front. To do this you need to select your numbers and press CTRL+1 to bring up the Format dialogue box. ...