It'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.
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.