Hi,

Do the following:

1. Enter a value in a cell.
2. Click the cell to the right and press Ctrl+R
3. Right-click the Auto fill handle of the selected cell and drag down
downwards.
4. When to release the right button, a popup menu is displayed.
5. Click Fill Series and you will notice that all cell values are filled ina
series - incremental.

Challa Prabhu

"Atreides" wrote:

Hi,

Does anyone know of a way to use Autofill with a keyboard shortcut? That
would be excellent. I think it's one of the few remaining reasons I have to
use the mouse in excel.

E.g. you select a column of text using the shift and arrow keys, then want
to autofil it across to the next column. Copy and paste works for simple
copies, but not it you want to extend the series (which you would have to do
with the drag handle in the corner of the cell)

Atreides