D3 =(B3^3.0)-(B2^3.0)
D4 =(B4^3.0)-(B3^3.0)
D5 =(B5^3.0)-(B4^3.0)
D6 =(B6^3.0)-(B5^3.0)
D7 =(B7^3.0)-(B6^3.0)

I rarely used Excel but since I don't have it installed on my computer I'm using Google Spreadsheets. Is there a way to formulate this so I don't have to keep on copying and pasting this formula?

  • can't you drag it down? – Raystafarian Jan 15 '14 at 20:56
  • @Raystafarian Doesn't dragging down move not copy? – puretppc Jan 15 '14 at 20:59
  • 1
    You have to drag the small square in bottom right corner or selected cell. Dragging from anywhere else will move the data – tumchaaditya Jan 15 '14 at 21:06

This is what you are looking for.




enter image description here


I've created an example file for you: ARRAYFORMULA

| improve this answer | |

Highlight the first one. Click and drag the handle at the lower right corner of the highlight and it will fill the area.

| improve this answer | |
  • +1 - also a good place to bring up cell reference anchors if you need the formula to remember a certain cell in the formula and not increment it along with everything else. support.microsoft.com/kb/214143 – panhandel Jan 15 '14 at 22:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.