Personally speaking.. I am keyboard fan and always endorse it over mouse, but every once in a while especially while creating some dummy data I use the fill handle in excel
Here are some pretty awesome fill handle shortcuts that I have learnt along the way!
Fill Months : Just write Jan/January (the case doesn’t matter) and drag it down
Fill Days of the Week : Write Mon/Monday (again the case doesn’t matter) and drag it down
Fill Dates : Write a date and drag it down to get a series of progressive dates
Fill any sequence that has numbers : You can write anything that starts or ends with a number and excel will nicely fill it up with progressive numbers
Fill Quarters : Write Q1/Qtr1/Quarter1 (again the case doesn’t matter) and drag it down
Fill Quarters along with Years: While filling quarter with years, make sure that the quarter number comes first (1 Qtr / 1 Q) and then write the year after that (1 Qtr 2016)
Fill Serial Numbers: Excel somehow does not fill the numbers just by dragging so hold the Ctrl Key while dragging
Fill Weekdays Only : By dragging using right click excel provides a couple of options to choose from – Weekdays, Months, and Years
Fill Linear Numbers : You can even click on Series and fill liners series at a step value
Fill Exponential Numbers : Just a liner series you can fill exponential numbers
I am sure I might have missed out some, if you use the fill handle tricks please add yours to the comments and let me know which ones did you like the most ?