How to drag formula in excel using keyboard?

Asked By:
4 answer(s)
Answer # 1 #

Select the cell with formula → Press Ctrl + C → Select target cells → Press Ctrl + V. This copies the formula without mouse.

[1 Month]
(2)
Answer # 2 #

Tip: Press Shift + Arrow keys to select multiple cells before using Ctrl + D or Ctrl + R.

[28 Day]
(2)
Answer # 3 #

For horizontal fill, use Ctrl + R. Select formula cell + cells on the right → Ctrl + R.

[1 Month]
(0)
Answer # 4 #

You can also use Ctrl + D to fill down the formula. Select the formula cell + cells below → Press Ctrl + D. Works for vertical copying.

[1 Month]
(0)

More Questions