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


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

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...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)