"If you've seen one of my seminars, you know that my favorite trick is to Double Click the Fill Handle to copy a formula down the the Data Set. Excel 2010 handles blank cells in the adjacent column much better than in previous versions." - Bill Jelen
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Rev up to Excel 2010. Chapter 14-Formula Copy.
Well, hey welcome back to the MrExcel netcast.
I'm Bill Jelen. By far my favorite trick what I'm doing in excel seminar is how to a copy of formula down to the bottom of the data set.
Now today, I only have 18 rows, so it's not that impressive, but imagine you had fifty thousand rows.
You need to copy this formula down to all those rows.
Well, what you do is instead of going to the fill handle and dragging like most people would do, I want you to get at little square dot, the fill handle and double-click.
All right, and it would shoot the formula right down now.
Check this out in Excel 2007, 2003, 2002, 2000, 97.
It always would have stopped at that blank cell.
Going to stop right there at row six, but now in excel 2010, they're smarter about this and it flies its way all the way down to the bottom of the data set.
That's beautiful. In fact, here's a data set, where I just went through and removed all kinds of things, as long as it can find a diagonal path to the bottom.
So from here to there, down to here over to there, down to here, it's going to find it's way down to row 18.
Watch double click the fill handle So even though the column to the left is almost completely sparse, it will find its way down to the bottom.
Beautiful improvement to one of my favorite features. It is a huge time saver.
Hey I want to thank you for stopping by. See you next time for another netcast from MrExcel.
Rev up to Excel 2010. Chapter 14-Formula Copy.
Well, hey welcome back to the MrExcel netcast.
I'm Bill Jelen. By far my favorite trick what I'm doing in excel seminar is how to a copy of formula down to the bottom of the data set.
Now today, I only have 18 rows, so it's not that impressive, but imagine you had fifty thousand rows.
You need to copy this formula down to all those rows.
Well, what you do is instead of going to the fill handle and dragging like most people would do, I want you to get at little square dot, the fill handle and double-click.
All right, and it would shoot the formula right down now.
Check this out in Excel 2007, 2003, 2002, 2000, 97.
It always would have stopped at that blank cell.
Going to stop right there at row six, but now in excel 2010, they're smarter about this and it flies its way all the way down to the bottom of the data set.
That's beautiful. In fact, here's a data set, where I just went through and removed all kinds of things, as long as it can find a diagonal path to the bottom.
So from here to there, down to here over to there, down to here, it's going to find it's way down to row 18.
Watch double click the fill handle So even though the column to the left is almost completely sparse, it will find its way down to the bottom.
Beautiful improvement to one of my favorite features. It is a huge time saver.
Hey I want to thank you for stopping by. See you next time for another netcast from MrExcel.
