Clearing Numeric Input From An Excel Spreadsheet

Erasing manual inputs from a spreadsheet that you want to reuse can be a tedious task. Despite our best intentions, entries often get saved into our master copies of spreadsheets that we reuse. Fortunately, you don’t have to go cell by cell to erase inputs. Specifically, we’re going to look at erasing numeric inputs, although you may be able to alter the technique to replace text-based inputs:

1. Select the cells that contain the data you want to remove, which can include numeric inputs, text, and formulas. To select an entire worksheet, click the top left corner of the worksheet frame, otherwise manually select two or more cells.
2. Activate Excel’s Home menu.
3. Choose Find & Select.
4. Choose Go To Special.
5. Choose Constants.
6. Clear the checkboxes for Text, Logical, and Errors, leaving only Numbers selected.
7. Click OK. Press the Delete key to clear the cells but keep the formatting intact.
8. If you wish to completely clear the cells, choose Clear and then Clear All on the Home menu instead.