How can I clear multiple cells in one click every time?

[jphilipose]

How can I clear multiple cells in one click every time? Any way I can set up some thing where I can click and clear bunch of selected cells in a large spread sheet?

[protonLeah]

Use the macro recorder. Select and clear the cells. Assign the macro to a button.