drag formula faster
 

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

drag formula faster
 

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
--
Brevity is the soul of wit.


"Churley" wrote:

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

drag formula faster
 

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.

Churley wrote:

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

--

Dave Peterson

drag formula faster
 

CTRL+SHIFT+Arrow down, CTRL+D

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Churley" wrote in message ...
| If I'm dragging a formula from cell A1 down to A50000, is there a faster way
| to get to the bottom?
| Thanks

drag formula faster
 

That worked! Thanks so much!

"Churley" wrote:

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