How to Apply a Formula to Multiple Rows - Google Sheets

Select the cell where the formula exists. Click and drag from the handle in the bottom right corner. The formula will now work on the data in the rows you selected.

[jessicamullin]

I like how you explained and then showed how to complete the task. This will save me so much time. Thanks

[chrisniesluchowski]

Thank You times a million. This was driving me crazy. Short and to the point video, like they all should be!!! Wish I could hit like a million times.

[continued.elsewhere]

Very Helpful. Thanks for being clear and to the point! Bravo!

[karman]

genuinely saved my life with this omg THANK YOU

[Snatch]

Thank you for this video! Thank you for being so brief! This saved me SO much time!!

[wallynassir]

Thanks Bro! Quick, easy and straight to the point!

[normcameron]

Thank you, you made finding a simple thing simple. So much simple stuff out there is made way too complicated and hard to find.

[grimesgamer]

thank you I have been trying for hours, youre the best for this

[cmnsmyc]

Very helpful and precise solution to my doubts, thank you!

[jz-wogl]

You're a life saver lol thanks put me at ease!

[drawwithkoko]

love! quick and easy to understand :D Thanks

[gramnet]

thanks I was able to create my formula .

[luz]

Is there a formula for when the rows are not right under one another?

[geniswatching]

is there a way of doing this for just copying the formula and not the colour of th cell etc.

[duongphan]

What if the row is too long to drag from top to bottom?

[ooywfbf]

I have 3 million rows, this is not very useful

[cmnsmyc]

Very helpful and precise solution to my doubts, thank you!