How to Create a Button to Clear Cell Value Keeping the Formats in Excel

How to Create a Button to Clear Cell Value Keeping the Formats in Excel?
Suppose you are creating invoices in excel and you need to follow the same three process every time.
1. Create Invoice
Now within this cycle you have a crucial task that is tiresome but overlooked. Removing the existing values from your invoice template. I’ve done several videos on clear cell button you can check them here:
All these tutorials do similar things. You need to chose based on your requirements. But in this tutorial, I’ll show a new technique that will allow you to clear cells but the cell formatting will be still three. You know, if you remove cell formatting ass well, you’ll have to create the template every time. But if you follow this advanced excel tutorial you won’t wave to worry about that. You can easily remove values from your invoice template and still keep the cell formatting intact. Now follow the below procedure to create a clear cell button in excel that will clear cell value keeping cell formatting.
This is an advanced excel tutorial & I’m going to use Excel VBA for this project. I am using Microsoft excel 2019 for the demonstration. But this tutorial is compatible with all the excel version from excel 2010 to above. Let’s get started.
Step 2: Click on Visual Basic
Step 3: Click "Insert" and then "Module"
Step 5: Close the VBE
Now we need to create button in excel. There are several tutorials on the channel to create buttons for VBA you can check them here:

Now that you’ve created a button, click on it. It will remove cell value from your predefined data range. This is how you Create a clear cell button in excel that doesn’t delete the cell formatting.

#ClearValue #Button #Excel

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[rachaelsmith]

Thank you! I have been trying to figure this out ALL DAY! You totally saved me!! :)

[hdotta]

thank you so much for a quick to the point video. These types of explanations are really missing from the youtube site!

[billie-grant]

Just used this video to help me with a reusable sheet! FYI I needed to delete data in a non adjacent cell separated using a comma ("B2:D2, I2:K2, M2"). Thank you for the video!

[latoyamartin]

This was helpful. I have a macro set up to clear fields but my issue is the formulas are also removed. How do I clear cells and keep the formula in certain cells ? Thanks

[iamsid]

THANK YOU SIR, YOU MADE MY WORK EASY 😊

[KhronicYT]

Thank you so much, I noticed there is no way to Cntrl+Z after the clear, is there a way to fix it or add a warning/ confirmation pop out after the click?

[yvonneprice]

How to I apply this to several worksheets? I have 5 in one workbook I'd like to clear individually.

[eusoj]

Can we use this button in a protected sheet without removing the protection?

[HitMan-jmge]

Is it possible to restore the data once cleared?

[rlrl]

How come it would not let me execute the command when there are merged cells in my range?

[fahimchoudhury]

How do I write the code? I am confused. Can you please write it for me.

[nelsonleon]

Everything I click on the cell it's delete the value, how can I keep the information when I click on the cell?

[thagish]

How to clear but not remove the formula?

[larrygarza]

Would be nice if you went slower in your explanation. I'm having a hard time understanding your steps.