Assuming the data is in column A and the formula in column B:

1. Enter the formula in B1

2. Copy cell B1

3. Navigate with the arrow keys to any cell in Column A

4. Press CTRLArrow Down

5. Press Arrow Right (you should now be in an empty cell at the bottom of column B)

6. Press CTRLSHIFTArrow Up

7. Paste (CTRLV)

Assuming the data is in column A and the formula in column B:

1. Enter the formula in B1
2. Copy cell B1
3. Navigate with the arrow keys to any cell in Column A
4. Press Ctrl+Arrow Down
5. Press Arrow Right (you should now be in an empty cell at the bottom of column B)
6. Press Ctrl+Shift+Arrow Up
7. Paste (Ctrl+V)