Deleting values in multiple cells is not a problem when the cells are continuous or located in a small spreadsheet. However, deleting cell values that are scattered around a large, complex spreadsheet is considerably more tedious unless you use Excel's Find All tool. This tool searches the spreadsheet for multiple instances of entered text and allows you to quickly select and delete them all. The tool also offers the option of selecting just text values or also formulas relying on those values.
Click and drag your mouse across multiple cells to restrict the search to only the selected cells. If you wish to search the entire spreadsheet, do not select multiple cells.
Hold the "Ctrl" key and press "F" to open the Find tab in the Find and Replace window.
Enter the text you wish to find in the "Find What" field.
Click the "Options" button to restrict or broaden the search. Check "Match Case" to find only values matching your exact capitalization. Check "Match Entire Cell Contents" to avoid finding text located within longer text. Click the "Look In" drop-down menu and select "Values" to avoid also selecting formulas that reference the searched value.
Click "Find All" to open a window displaying references to all cells matching your search criteria.
Hold the "Ctrl" key and press "A" to select all the referenced cells.
Click "Close" to close the Find and Replace window.
Press "Delete" to delete the contents of all cells matching your search criteria.