Software

How to drag formula in excel using keyboard?

4 answer(s)
Answer # 1 #

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

[2 Month]
(5)
Answer # 2 #

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

[2 Month]
(4)
Answer # 3 #

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

[3 Month]
(3)
Answer # 4 #

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

[2 Month]
(2)

Related Questions