Hints and tips home » Excel hints and tips » Deleting a range of cells using the autofill handle

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

Added by Phil on 28th November 2006

More Excel hints and tips, like:

• Pivot table grouping
• Create and delete borders
• Make a quick copy of a worksheet