Double-click to fill only works if you have an adjacent column with data.

The d-click will fill down to end of data in that column.


Gord Dibben MS Excel MVP

On Fri, 23 May 2008 06:35:00 -0700, Chris Lukowski
wrote:

I've read the double clicking tip before but it doesn't seem to work in Excel
2007. I highlight the cell range to auto fill, I double click the fill handle
square, nothing happens. :( The second tip would just copy the contents of
the cell instead of continuing a series, would it not?

"John Bundy" wrote:

Double clicking the fill handle fills the data down. If that doesn't do it
for you copy the cell hold shift tap End and then tap the down arrow.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Chris Lukowski" wrote:

I often select cells and use the fill handle to populate data in my
worksheets, but it's a royal pain using my mouse to drag the fill box all the
way down a spreadsheet containing thousands of rows. Is there a keyboard
shortcut to dragging the fill handle to the top/bottom of the sheet, or even
use page up/down if that's not possible? Thanks.