Excel shortcut key

[slim]

Hi guys,

A simple excel shortcut key question.

In a excel 2000 worksheet you can extend the series by clicking and dragging.

But does anyone know if there is keyboard shortcut key for this or how to make one???

Thanks

Slim

[Paul Komski]

Slim I don't have excel installed at the moment so unable to play with it and check this out. Also I'm not sure what you mean by extending the series.

There is a way to produce customised shorcut keys and to use them to run a macro. So if you can get a macro to do what you want then just link it to your own customised shortcut key.

[slim]

Paul

I will try to explain this better.

If you put a value in cell "A1", then decide you want to copy that value to the cells directly beneath "A1", you can click on the corner of cell "A1" and drag to extend the series so the other cells contain the same value, without the need to copy and paste.

I also thought about the macro solution, which would be only a few simple lines of VBA, but I was asked if their was a shortcut key already setup in excel.

Hope this makes sense.

Regards

Slim

[Paul Komski]

CTRL + ' (Control + single quote) will copy the cell above into the cell below it (that one that contains the cursor) in both excel spreadsheets and access tables and datasheets.

I don't know of a way of "extending the series" by more than one cell at a time without a macro; and that macro would only do it for a specified number of "jumps" unless it also prompted you for a number in an input box. A macro like that would need some VBA.

But you don't need to write any VBA to achieve a result. Just start a macro, do the action(s) you wish to be able to replicate and stop and save the macro. Then assign your own shortcut key to it.

Hope this helps. You can have a bit of fun experimenting anyway! ;)

Two possible macros to record:
(a) CTRL + ' followed by the down arrow.
(b) Move to the Cell Above; drag down the value one cell; then move the cursor to the cell below that.
Then just keep pressing the assigned shortcut key the number of times you need it.