• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fill Handle Series

Debraj

Excel Ninja
Is there any Keyboard Shortcut..

to fill Handle Series.. Just like Double Click at the bottom Right Corner of selected Range, and it will fill to the last used Cell (on left/Right)

PS: (Alt+E+I+S) wouldn't worked in case of JAN,FEB..
 
Hi, Debraj Roy!

Ctr-D is the shortcut described in the cool link that b(ut)ob(ut)c posted, but it's language sensitive. So it works in English versions, in Spanish versions you should use Ctrl-J.

Regards!
 
Hi bobhc,


You are the second BOB (after Bob Umlas) who is showing me this trick.. :)


Let me clear, I don't like to use MOUSE when working with Excel.

In fact I use Shift + F8 to select non-contigious cells.

b(ut)ob(ut) I fail when need to fill bobhc 1, bobhc 2, bobhc 3... in next Row / Column, and Mouse passed with full marks.. :)


I have lots of Shortcuts to work

*(Ctrl + ') - Fill Down Formula

*(Ctrl + ") - Fill Down Value

*(Ctrl + D) - Fill Down Formula + Value

* Alt + E + I + S (Edit > Fill > Series)

but none of them works in case of Custom List or Word with Number Suffix.

I just want keyboard shortcut to

Code:
Selection.AutoFill Destination:=Range("A1:A15"), Type:=xlFillDefault


Thanks..
 
He doesn't know excel, he knows MAGIC.. :)


http://books.google.co.in/books/about/This_Isn_t_Excel_It_s_Magic.html?id=-i4RTOdO_fYC&redir_esc=y
 
Back
Top