When Clearing Cells Is A Drag
by Francis Hayes (The Excel Addict)
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.
I know...if you want to delete the contents of cells it's easier just to select them and press Delete. But this is just a strange little feature of Excel that I thought I'd show you.
Just 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 become grayed out as you drag. Release the mouse button and the cell contents are gone.
Interesting but probably not very useful.
|Copyright © 2015
Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.