| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Drag a Named Formula | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How do I set one cell as a constant so I can drag the formula | Excel Discussion (Misc queries) | |||
Linear Mode
