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
|