Excel Tips – How to Select All Cells Matching A Particular Criteria in Excel 2010

Excel Tips – How to Select All Cells Matching A Particular Criteria in Excel 2010 What do you do if you need to select all cells matching a criteria like a specific word, character or value and you want to look at each cell individually… and then possibly edit them? And if these cells are scattered all around the worksheet? Well I have found a trick to make this very easy to do. Let’s look at an example. Say you want to locate all cells in your spreadsheet that contain the word Rental. Press CTRL+F and type Rental in the ‘Find what’ field. Click the Find All button and all cells containing the word ‘Rental‘ will be listed at the bottom of the ‘Find and Replace‘ dialog. Pretty cool, huh? Now, here’s the best part!  With the ‘Find and Replace‘ dialog still open, pressing CTRL+A will select all of the items listed at the bottom of the dialog, and it will also select these cells on the worksheet. At this point, you could close the Find and Replace dialog and all o
http://bit.ly/1quZ3Nm

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s