The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
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 t
his is just a strange little feature of Excel that I thought I'd show you.

Drag Fill handle to clear cells

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.

Would you believe me if I told you that
you can DOUBLE your productivity in Excel?

How about TRIPLE it ? or QUADRUPLE it ? or MORE ?

If I showed you a tip where you could do a task in Excel in five seconds that would typically take you 20 minutes to an hour or more, what would you call that? Productivity on steroids?

...and that's just ONE tip!
"Give me 10 or 15 minutes each week and I will show you how learning a few of my time-saving 'Spreadsheet Tips From An Excel Addict' on a regular basis will seem almost effortless BUT will quickly help you BOOST your productivity in Excel beyond your imagination" - Francis Hayes, The Excel Addict

Get my FREE Weekly Newsletter for FREE
"Spreadsheet Tips From An Excel Addict"

Now being read by more than 35,000+ Excel Addicts all over the world

Enter Your Name Francis Hayes (The Excel Addict) - I want to help you EXCEL !!
Enter Your Primary Email

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.