Share [Social9_Share]

Fill Handle Shortcuts in Excel

Fill Handle Shortcuts in Excel

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!

 

Using the fill handle you can!

Fill Months : Just write Jan/January (the case doesn’t matter) and drag it down

Fill Months using Fill Shortcuts

 

Fill Days of the Week : Write Mon/Monday (again the case doesn’t matter) and drag it down

Fill Days using Fill Shortcut

 

Fill Dates : Write a date and drag it down to get a series of progressive dates

Fill Dates using Fill Shortcut

 

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 sequence using fill shortcut

 

Fill Quarters : Write Q1/Qtr1/Quarter1 (again the case doesn’t matter) and drag it down

Fill Quarters using fill shortcut

 

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)

  1. Notice the space – 1Q/1 Q (both will work fine)
  2. In between the Quarter and the year you can have any character : a space, colon stroke etc.. (1Q 2016/ 1Q-2016)

Fill Quarters and Yrs

 

Fill by holding the Ctrl Key

Fill Serial Numbers: Excel somehow does not fill the numbers just by dragging so hold the Ctrl Key while dragging

Fill Serial Numbers using fill shortcut

 

Drag Fill Handle by Right click

Fill Weekdays Only : By dragging using right click excel provides a couple of options to choose from – Weekdays, Months, and Years

Fill Weekdays

 

Fill Linear Numbers : You can even click on Series and fill liners series at a step value

Linear Fill

 

Fill Exponential Numbers : Just a liner series you can fill exponential numbers

Exponential Fill

 

Which ones are your favorites?

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 ?

 

Some more Shortcuts that you can download

  1. 100 Excel Shortcuts Pdf
  2. Financial Modeling Shortcuts that I use
  3. PowerPoint Shortcuts
  4. VBA Shortcuts
  5. Excel Shortcuts for Mac Users

 

  • GraH

    Actually, the case matters. The fill handle will use the case setting you used. If you would type JANUARY, then all months are also in capitals.
    And if you happen to have made custom sort lists, they are also recognized by the fill handle.

    But also picked up a new one here: fill by holding the CTRL key.

Chandeep Chhabra

Popular Posts

© Goodly