How to Reset an Excel Spreadsheet for Data Entry

Spreadsheets and graphs on a desk

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:

  1. 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.
  2. Choose Find & Select from the Home tab.
  3. Choose Go To Special.
  4. Double-click on Constants to skip the OK button within the Go To Special dialog box.
  5. Press the Delete key to clear the cells but keep the formatting intact. No formulas within the range you selected will be affected.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.