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.
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
how
much time you'll save just by
learning a few of these tips.