|
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.
Why not print (CTRL+P) this tip and share it with your friends and associates?
|
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/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright © All Rights Reserved by
|
Close this window
|