Excel Magic Trick 1241: Keyboard To Copy Formula Next To Data Set Down A Column

Learn how to use Keyboard Copy Formula Down When Formula Is Not Directly Next To Data Set.
Keyboard:
1. Ctrl + C
2. Ctrl + Left Arrow
3. Ctrl + Down Arrow
4. Right Arrow
5. Right Arrow
6. Ctrl + Shift + Up Arrow
7. Ctrl + V

or:

1) Ctrl + Left Arrow
2) Ctrl + Down Arrow
3) Right Arrow
4) Right Arrow
5) Ctrl + Shift + Up Arrow
6) Ctrl + D

Two other videos about copying formulas down:
Excel Magic Trick 1064: Copy Formulas Even More Quickly With F5 Key and Shift + Enter
and
Excel Magic Trick 1061: Copy Formulas Quickly With Name Box and Shift Key (Horizontal or Vertical)

[jangje]

Usefull tip if you work with big data.
Ctrl + D also works.

[Sal_A]

Mike - haven't tried this, but what about Shift + Left Arrow, Ctrl + D?

[ExcelStrategy]

The highlight of the cell/cells between the column and the cell containing the formula goes directly in my tricks repertoire ! Iv just noticed one thing, the trick works only if the selected cell is the one attached to the data column, if the selected cell is the one containing the formula the trick does not work.

[Reduce_Scan]

This is a good idea
How many zeros after the last number

As well
The number of zeros in full cell

I hope the work of this clip for the idea and provide this solution
With thanks and appreciation

[killerhunk]

You can also use ctrl + D instead of copy and paste.

[mnsoyan]

Anybody knows a way to copy the exact formula without changing the cells references? (I know we can click on the cell, highlight formula and paste it in another cell...but that is too long, especially if we have many cells).