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.
Steps:
- 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.
Your sheet should now look like this
Next Lesson: Teach Yourself Excel Lesson 15 - Insert A Column
Training Video on how to copy A Formula in Excel:
| Attachment | Size |
|---|---|
| copy-a-formula.xls | 29 KB |
»
- Nick's blog
- Login or register to post comments
- 10332 reads
retrieve text from DOS
hi,,,i want to copy some text from an already opened window//
I also wana check(compare) the written text in DOS window with mine,, like i wana check wht is written in 2/5 cursor position in dos or a dos like window(screen),,,can u plz suggest some code.
i already got the code to reach that already opened window,,just want code for retriving text from DOS>
thanks..
a friend