How to use keyboard to simulate the mouse drag operation?

[woshichuanqilz]

We know that the excel has two useful operation that drag the corner of a cell and then cover the range you want to change. And method two you can click ctrl while drag the mouse you will get a increment of the selected range.

Is there a way to use keyboard to make it?

[:) Sixthsense :)]

Select the initial value cell and extend your selection and press Alt+E+I+S.