let's say I've created a formula and now
we want to copy that formula to the rest
of the rows in my spreadsheet you may
already know that you can copy cells by
dragging the fill handle which is this
little square here but if you have a lot
of rows this can be pretty awkward in
this case I have 300 rows your
spreadsheet might actually have
thousands of rows or even more luckily
there is a shortcut just double click
the fill handle and it will copy the
formula down automatically if we scroll
down you can see that the formula has
been copied all the way down to the end
of our data and it's just looking at the
other columns and seeing where the data
ends and then trying to match that so I
recommend using this shortcut whenever
you can
Goodwill Community Foundation creating
opportunities for a better life