Is there a shortcut for drag in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a shortcut for drag in excel

You often need to replicate the function you just did in the last cell. This is normally done by pointing the cursor on the lower right corner of the cell, and a little black cross appears. Then the function can be copied to the cells below, above, to right or left, by dragging the little cross with the mouse

I find it tediuos that I have to use the mouse for this action (now that I have become accustomed to shortcut keys)
Is it not possible to use the arrow-keys in combination with another key to do this

Thank

Steen
 
Hi
one way:
- CTRL+C to copy the formula
- CTRL+V to insert the formula into a new cell
-----Original Message-----
Is there a shortcut for drag in excel?

You often need to replicate the function you just did in
Click to expand...
the last cell. This is normally done by pointing the
cursor on the lower right corner of the cell, and a little
black cross appears. Then the function can be copied to
the cells below, above, to right or left, by dragging the
little cross with the mouse.
I find it tediuos that I have to use the mouse for this
Click to expand...
action (now that I have become accustomed to shortcut
keys).
 
Back
Top