We have already written the macro SmartDel and assigned a keyboard shortcut <Alt>+<Del> to it. Now save the project as an Excel add-In to make it convenient to use the macro.

Read more »

Easy way

• Open the Tools menu, choose Macro then Macros
• Select the macro SmartDel
• Click on the button [Options]
• Set the Shortcut key <CTRL> + <Symbol>
• Done!

But this method doesn’t allow set hotkey like <CTRL> + <Del> or <ALT> + <Del>.
Read more »

Sometimes working with Excel need to clear cells with numeric data only and leave cells with formulas and text. Today we’ll write macro SmartDel, which clear cells with numers in the selected range.
Read more »