"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Excel Experts"

The Fill Handle Secret


In past tips I've showed you how to copy formulas and fill dates by dragging the Fill Handle (the small black square on the bottom-right corner of a selected range of cells). When you do this, Excel guesses what you want to do based on what is contained in the selected cells. However, sometimes you don't get what you want.

Do you know there is another secret hidden in that Fill Handle that most Excel users are unaware of. Those who have uncovered this secret, have gained complete control of Excel's fill options. Now I will share it with you.

Instead of dragging the Fill Handle while holding down the left mouse button, try it by dragging with the right mouse button. When you release the mouse button, a menu will pop up giving you a list of fill options.

Need to add a range of dates 2 weeks apart on your sheet. Enter a starting date in the first cell, then right-drag the Fill Handle for how many dates you want. Click Series, type 14 in the 'Step value' box and click OK. How about a series of dates for the 15th of each month. Enter a starting date, right-drag the Fill Handle for how many dates you want. Click 'Fill months' and click OK.

Go ahead! Try it out. You'll find lots of everyday uses for this hidden treasure.


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 www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.