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.
About David Ringstrom, CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.