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.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

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.


Please login or register to join the discussion.

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