View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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