One of my Greatest Hits a fast way to copy a formula down to all rows. Episode 579 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey welcome back to the MrExcel netcast. I'm Bill jelen.
Today I'm gonna do one of my greatest hits, one of my favorite tips of all time. It's a really short tip.
It's Friday, but just in case you weren't watching when we first showed this tip.
We have a formula here in cell B2 and some thousands of number of cells in column A and I need to be able to copy this formula down to all of the cells but it's very frustrating if I start to click the fill handle and start to drag down.
Excel starts going faster and faster and faster and faster and Excel always overshoots the end of the data.
It's just invariable that you end up way too far and you put on the brakes and you start dragging back up and again Excel starts going faster and faster and faster and faster and before you know it you've flown past the end of the data again.
Well, this is very frustrating to go back and forth back and forth.
I call it doing the fill handle dance, trying to find the end of the data.
Well, the much better way to go, rather than dragging the fill handle to copy the formula is just simply to double click the fill handle.
Double click right there.
Excel will look to the column to the left, figure out how many rows of data I have and copy the formula to the exact number of rows.
You always want to hit the End key And then the down arrow to make sure that Excel made it all the way to the end.
If there was a blank cell in Column A it would have stopped prematurely.
So always make sure that your data is copied down.
My favorite trick of all time.
Double click the fill handle.
Hey. Thanks for stopping by. We'll see you on Monday for another podcast from MrExcel.
Today I'm gonna do one of my greatest hits, one of my favorite tips of all time. It's a really short tip.
It's Friday, but just in case you weren't watching when we first showed this tip.
We have a formula here in cell B2 and some thousands of number of cells in column A and I need to be able to copy this formula down to all of the cells but it's very frustrating if I start to click the fill handle and start to drag down.
Excel starts going faster and faster and faster and faster and Excel always overshoots the end of the data.
It's just invariable that you end up way too far and you put on the brakes and you start dragging back up and again Excel starts going faster and faster and faster and faster and before you know it you've flown past the end of the data again.
Well, this is very frustrating to go back and forth back and forth.
I call it doing the fill handle dance, trying to find the end of the data.
Well, the much better way to go, rather than dragging the fill handle to copy the formula is just simply to double click the fill handle.
Double click right there.
Excel will look to the column to the left, figure out how many rows of data I have and copy the formula to the exact number of rows.
You always want to hit the End key And then the down arrow to make sure that Excel made it all the way to the end.
If there was a blank cell in Column A it would have stopped prematurely.
So always make sure that your data is copied down.
My favorite trick of all time.
Double click the fill handle.
Hey. Thanks for stopping by. We'll see you on Monday for another podcast from MrExcel.
