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


Excel Tips How to Select All Cells Matching A Criteria in Excel 2010 Let s say 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. Typically, these cells are scattered all around the worksheet. What s the best way to locate all of these cells? 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. Now, here s the best part! Now 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 of the found cells will still be selected on the worksheet. However, the
http://bit.ly/1N3a7ij

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