drag formula faster

C

Churley

If I'm dragging a formula from cell A1 down to A50000, is there a faster way
to get to the bottom?
Thanks
 
D

Dave F

You can enter a period or some other holder in A50001 then hit CTRL up arrow
to get back to A1, highlight A1, then hold Shift + CTRL + down arrow to
select everything from A1:A50000 and hit ctrl+D.

Dave
 
D

Dave Peterson

select A1:A50000
(One way: Edit|Goto, type A1:A50000 and hit enter)

Type your formula for the activecell (A1 normally)
but hit ctrl-enter to fill the selection instead of just enter.
 
N

Niek Otten

CTRL+SHIFT+Arrow down, CTRL+D

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| If I'm dragging a formula from cell A1 down to A50000, is there a faster way
| to get to the bottom?
| Thanks
 
Top