TheExcelAddict.com
Microsoft Excel 'Quick Tip'

When Clearing Cells Is A Drag

By now you are probably familiar with using the Fill Handle. But here's something you may not know. You can also use the Fill Handle to clear the contents of a range of cells by dragging it backwards over the current selection.

Clear cells by dragging the Fill Handle backwards in Excel

Try it. Select a range of cells that contain the data you want to clear. Now drag the Fill Handle backwards over the selected cells. You'll notice that the cells turn gray as you drag. Release the mouse button and the cell contents are gone. The neat part about this is that the cell formats are not affected.

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict"

Subscribe at the TheExcelAddict.com and impress your coworkers with your newfound Excel skills.

You'll be amazed at ho
w much time you'll save just by learning a few of these tips.

Copyright © All Rights Reserved