Most of us have probably used the Find function in Excel, the binocular icon found under the Home ribbon in Excel 2007. So now it's time to supercharge its use. These tips will increase your efficiency and effectiveness the next time you go to search for something in Excel.
First, get away from the mouse; you can use Ctrl + f to pull-up the Find function. This will save you the time of going to click on the Home ribbon, and then moving your mouse over to the binocular icon. Having to remember this simple shortcut key is well worth the time savings. Download a listing of must know shortcut keys here.
For example, to select everything - click on the first item > hold down the Shift button > go to the end of the list > click on the last item (you can also use the down arrow key). Or, maybe you just want to select a few results. Click the first one in the list you want, then holding the Ctrl key select the others.
Once you've selected the items you want you can modify the items selected. One handy trick, especially if you're interested in other data included on each row that you've selected, is to use the Fill option to highlight the cells a particular color. You can then use the Filter by Color option to just view the highlighted cells.
You can expand your search from an individual Sheet to the entire Workbook, or change your search so that it goes By Rows (i.e., starts in Cell A1 then goes B1, C1, etc; then moves to the next row) or By Columns (i.e., starts in Cell A1 then goes A2, A3, etc; then moves to the next column). You can also narrow the search so that its only looking in Formulas, Values, or Comments.