Ask anyone who takes an Excel Basic class and they’ll tell you one of the best tools in Excel is called the auto-fill handle. You might know it more commonly as the black plus sign you get when hovering over the lower-right corner of a selected cell. If you drag the fill handle down the spreadsheet, your formula copies down to each row you select.

But what if you have hundreds or thousands of rows? That’s a lot of dragging.

Next time, write your formula, then when you see the auto-fill handle double-click on it. Your formula automatically copies down to every row that has data next to it. And you know what ? It’s still handy if you only have 3 rows.

Author:  Ryan Donelan
rdonelan@microknowledge.com

Remember, if you are a MicroKnowledge customer and have a software question to ask, feel free to contact us at any time by using our Support link at the top of the site. Your question might be featured in our next blog entry!

Do you have a related tip to share? Leave a comment. We’d love to hear from you.

Category: Tech Tips