Excel Tip Tuesday: The fill handle has other options

Posted by Lisa on May 22, 2018 at 10:00 AM

Excel IconIt's fairly common practice to right-click on a cell - or a group of cells - to get some additional options. These options broaden what you can do with the content of that particular selection. But did you know that right-clicking just the fill handle offers a whole other set of choices?

These choices have to do with how the selected range of cells should be filled. It's most effective when you right-click the handle and drag. When you release, you'll see options such as 'Fill Formatting Only', 'Fill Without Formatting', 'Fill Days', 'Fill Years', 'Series...', and so on. These selections give you control over the content you use to fill those cells.

Excel Tips - Right-Click Fill Handle

Go ahead and experiment with these options to see how you can gain greater command over the way your spreadsheet fills with data.

Leave us a comment and let readers know what Excel tips you use on a daily basis.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts