How To Fill Down Formulas
Learn how to efficiently fill down formulas in Google Sheets using quick methods like double-clicking the fill handle or using the Command D shortcut. This video provides practical tips to save time when working with large datasets.
So I'm filling out this formula I want to combine the unit sold and unit price and get a total revenue, and this is a formula B, two times C two. But I wanna fill this down and I could copy paste this all the way down. If I have hundreds of rows, that might take a while. I could also do one of two things that are very, very quick. One is this. Dot on the bottom right, if there is actually data filled in in the C column, in the column next to it, I double click and just doing that will fill down all the way. There is one more way I could select all of the rows that I want to fill down on. And I can use command D shortcut. So that's command D to fill down. Command D also works if I select two columns and I want to fill
it all the way down in these two columns, just one command. We'll fill down both of these rows and you can see the formulas are updating. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.