Reset a Worksheet with a Button Click

Add to Favorites
Author: | Edits: don

How to reset the values, formatting, and formulas for an entire worksheet with a single button click.

This allows you to clear or reset Excel templates, forms, inputs, ranges, and more wth ease.

This tutorial does use VBA and macros, but they are covered in such a way that anyone can follow the examples and apply the techniques to their own project, regardless of programming skill or knowledge.

You will also learn how to use the Macro Recorder to easily figure out how to do new things in VBA.

Code to Clear a Cell 

Worksheets("Input").Range("D3").Value = ""

Input is the name of the worksheet.

D3 is the cell to change.

Code to Reset a Cell's Value 

Worksheets("Input").Range("D3").Value = "10"

Input is the name of the worksheet.

D3 is the cell to change.

10 is the value to put into the cell.

Additional Resources

Macro Recorder (Microsoft's Page)

Clear Values Method for VBA (Microsoft's Page)

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Put Data into a Worksheet using a Macro in Excel
Tutorial: How to input data into cells in a worksheet from a macro. Once you have data in your macro...
Run a Macro when a User Does Something in the Worksheet in Excel
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...
Enter Text/Characters with a Double-Click of the Mouse
Macro: This macro allows you to enter any text or number, that you specify, in a cell on whic...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Hide Data Within a Worksheet in Excel
Tutorial: In Excel you can actually hide data that is stored within a worksheet. This allows you to ...
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...