Excel Auto-Fill Without Mouse (Keyboard Only) - Super User

You could also assign your own custom short-cut key to the "fill series" option... and then it would give you ... Copy that cell and drag to last sell of required data .

superuser.com