How to Write a Reset Macro for Excel

Video Transcript

"Microsoft Excel is a registered trademark of Microsoft Office Products and I am in no way, shape or form, affiliated with Microsoft Office or Microsoft. Okay, now I want to create a macro that resets a sheet back to its original form. So, as you can see, I've got a set of rows, row numberings set up here and what I want to do is go to tools and since I have the visual basic open, I can just go ahead and click on a macro and call it clear sheet so that we can set the macro back to where it was before. And then, we got to pick a letter to go with it. In this case, I'm going to click T. Now, just so we know, when we hit Control T, each time it's going to reset the page back to its normal state. Okay. Now, if I go to another sheet, and I go ahead and type in our data that we want to use, you can either pick to run a macro, you can click, clear sheet, or you can actually go here and go Control T, and it will do the exact same thing."