Excel Magic Trick 1241

DESCRIPTION

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

WORKBOOKS