Hi learning,
No you do not need to write in any formulas...Originally Posted by learning
Do you know that you can just drag the formulas down as far as you want? For cell references without a $, Excel changes the formulas appropriately. They are called relative cell references, like A1
If you add $’s like $A$1 then that fixes them, and so by dragging down they do not change. In your formulas, for example you have $B$3. That means you always use that cell value. It does not change when you drag it down. it is called an absolute reference
Without the $’s in the cell references, the cell formulas change automatically as you drag down.
You do not need to type in any formulas – just drag down and it fills a them in all in one go !
To fill in a massive amount of your formulers without writing a single thing:
_ Select, for example, F95 to I95 in the original chart
_ Move the mouse to the small black square at bottom right of the selection. A black + should appear.
_ Hold the left mouse down on that + and drag the formulas down as far as you want.
DragFormulasDown.JPG http://imgur.com/H5378wI
DragFormulasDown.JPG
This probably explains it better than I can:
https://support.office.com/en-us/art...3-83aa1a63e218
Alan
Reply With Quote
Bookmarks