Click Find All and Excel will list all the cells, but you’re not done. Press [Ctrl]+A to select all of referenced cells in the list. Then, click Close to select those cells.

Microsoft Excel’s Find feature is one of its most flexible tools in the entire toolbox. You can do much more than just find and replace data. ... How to select cells using Find All in Excel.

Launch Microsoft Office Excel 2010 and open the spreadsheet you want to edit. Press "Ctrl-F" to launch the Find and Replace feature. The Find tab should be selected by default; if it's not, select it.