From time to time you may want to remove words or numbers from Excel worksheet cells while keeping formulas intact. This can happen when a user inadvertently forgets to save a worksheet as a new copy.
In this article I’ll explain how to reset an existing workbook, but also show you a way that you can minimize the need to use this technique in the future. As shown in Figure 1, to remove text or numbers from a worksheet:
- Select the cells that contain the information you wish to clear. This block of cells can include formulas, which is often what poses the challenge for many users.
- Choose Find & Select from the Home tab.
- Choose Go To Special.
- Double-click on Constants to skip the OK button within the Go To Special dialog box.
- Press the Delete key to clear the cells but keep the formatting intact. No formulas within the range you selected will be affected.