Microsoft Excel Favorite Tip.
Today, October 17, 2022 is International Spreadsheet Day. Microsoft has asked a lot of creators to post their favorite Excel tips. Here is mine: Double-click the Fill Handle to copy a formula to the bottom of the data.
How to copy Excel formula to the bottom of the data set by double-clicking the Fill Handle.
Today, October 17, 2022 is International Spreadsheet Day. Microsoft has asked a lot of creators to post their favorite Excel tips. Here is mine: Double-click the Fill Handle to copy a formula to the bottom of the data.
How to copy Excel formula to the bottom of the data set by double-clicking the Fill Handle.
Transcript of the video:
Hey, I'm Bill Jelen from MrExcel.
What's my favorite Excel tip of all time? So you have a formula, any formula, and you need to get it down to the bottom of the data. But your data?
Ah, there's gaps. Control down arrow doesn't work from any column.
Awesome trick here. Select the formula, double click the fill handle right there. Excel looks at all of the columns to the left, finds its way to the bottom. Even if it has to make a diagonal hop from Adele to Mantovani. From Usher to Liberace, back to Beyoncé, it'll find its way to the bottom. Next time you have to get a formula down, give it a try, double click the fill handle. Thanks for watching Excel at Everything. If you like this video, please, down below, Like, Subscribe and Ring the Bell. Feel free to post any questions or comments in the comments below.
What's my favorite Excel tip of all time? So you have a formula, any formula, and you need to get it down to the bottom of the data. But your data?
Ah, there's gaps. Control down arrow doesn't work from any column.
Awesome trick here. Select the formula, double click the fill handle right there. Excel looks at all of the columns to the left, finds its way to the bottom. Even if it has to make a diagonal hop from Adele to Mantovani. From Usher to Liberace, back to Beyoncé, it'll find its way to the bottom. Next time you have to get a formula down, give it a try, double click the fill handle. Thanks for watching Excel at Everything. If you like this video, please, down below, Like, Subscribe and Ring the Bell. Feel free to post any questions or comments in the comments below.
