We are in the process of updating the site, so some pages still have the older design.
Excel Workbook Reset with a Single Button Click [Easy Version]
How to easily clear or reset an entire workbook, specific worksheet, or just a few cells with a single button click in Excel.
This tip requires using a very small amount of VBA, but I will walk you through all the steps to get it to work and I promise that everyone can do it.
Clearing the data is the same as deleting the data.
Resetting the data is the same as setting it back to default values.
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Phone number is optional - we use it to send course discounts and weekly updates via SMS.
View our Privacy Policy | Terms of Use
Question? Ask it in our Excel Forum
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.)
Tutorial: How to quickly export the current worksheet as a PDF by clicking a single button. This al...
Tutorial: How to reset the values, formatting, and formulas for an entire worksheet with a single b...
Tutorial: Using this method, you will be able to use checkboxes to control custom conditional format...
Tutorial: How to use a single formula to apply conditional formatting to multiple cells at once in ...
Macro: This macro in Excel allows you to display or show a particular comment in Excel. This will...
Tutorial: How to quickly combine any part of an entire list of values into a single value in a sing...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)