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