Teach Yourself Excel Lesson 14 - Copy A Formula
Copy A Formula
In the last lesson, we entered a formula. We now want to apply that formula to all the dates in column A.
There's a quick way to copy a formula that saves us from entering it again and again.
- Select range F1 and G1 (the 2 cells)
- In the bottom right of your selection, there is a small black square
- Double click on this.
- The formulae will now be copied down to the end of the data, and they will recalculate.
Next Lesson: Teach Yourself Excel Lesson 15 - Insert A Column
Training Video on how to copy A Formula in Excel: