How to Copy a Formula Down an Entire Column in Google Sheets

[@ingarab.3486]

I made 3 hours to make a complexe formula and I saw this ....Thank you so much

[@mariagratielaifrim3859]

Great learning. Thank you

[@xxpirategamingxx7994]

Thank You, NO CLICKBAIT UNLIKE other videos

[@asifm5153]

In mobile phone, long touch the cell with formula and touch Copy, then drag the "fill handle" to the end of the column and touch Paste Special>Formula Only

[@monsteraetc]

Thank you. I was about to throw my ipad across the room…🤬

[@JaderPintoSantos]

you can even change the header to '=arrayformula({"SUM",A2:A+B2:B})' and it will put the formula in the header so you can filter and order the numbers below without messing with the formulas.

[@Silver2004Avalhadia]

Thank you so much!

[@dheneh2478]

I don't have a square option that appears.. I only have a dot, when I double click it, it doesnt do anything :( I do have a formula in the cell that is functional

[@harshrathore1262]

great video, this video is a life saver.

[@karengoodman9178]

This doesn't work on a tablet no drag square ...help !

[@wasidhossain3848]

ARRAYFORMULA just saved my time, thanks

[@leybertjaictin2784]

thank you big help for my work

[@dixiediamond5344]

Easiest to follow video yet!!!

[@seraeggobutterworth5247]

Is there any way to do this on an iPad? No fill handle available, as far as I can see.

[@saficontreras9983]

Thank You

[@QuranKareem_MaherAlMuaiqly]

great work

[@jamiex6505]

Omg I didn't know this. Thank youuu!!

[@deniseross9387]

Very helpful! Thank you

[@MartijnMols]

can you use the fill handle on the entire row instead of column?

[@HarshSharma-id7eo]

Thank You Sir 🙌🙌

[@nic3539]

We can copy the cell that already input formula and select 'paste formula only'.

[@landojr2136]

holly molly , this is the best

[@rajshri1279]

I did the double click and the drag but its coping the same number

[@ModernSchoolBus]

Does the cell you are copying have a formula in it?

[@sidneyis128]

It doesn’t work on mobile

[@martinschmidt1652]

A bit more speed please...

[@antonioileo2624]

=SE(A11:A1000"";ANNO(A11:A1000)) un aiuto per favore creare un array formula

[@E_steban]

Get to the point!!!

[@7085445452]

Thank you so much! This was exactly what I needed 😀😀

[@ModernSchoolBus]

Thank you. I'm glad you found it useful!

[@dixie-annhunteblackman6003]

Thank you

[@ModernSchoolBus]

Glad you found it useful!