[Chris Lukowski]

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.

[John Bundy]

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.

[Chris Lukowski]

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.

[Tim879]

you could just use the menu shortcuts..

use the tip above to highlight the selected range then

hit alt - e - i - s to bring up the fill series menu...

you could also assign a shortcut key to this command. just look up the
help file for Assign or change a keyboard shortcut

On May 23, 9:35 am, 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.

[Gord Dibben]

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.