pasting and navigating down a long column?

B

Boatman

When I first started using spreadsheets years ago, LOTUS 1-2-3 had a nifty
way to quickly paste down a long column in a 2D table. I forget now exactly
how it was done, but it involved only a few keyboard strokes using, I
believe, the arrow keys, END, and the decimal point or period key. I am sure
(hopefully) Excel has something just as easy, but I have never been able to
figure it out. I have tried using GOTO (cntrl-G) but no luck.

Here is a clarification of what I did with LOTUS: With the first cell in a
particular column selected, I would cntrl-C, then if the column was
continuous, a few keystrokes would instantly highlight the entire column,
ready for a paste operation. If the column was not continuous (or even
empty), but an adjacent or neighboring column was continuous, slightly
changing the keystrokes would still allow me to highlight my column as
before. It was very fast and automatic for those long, big spreadsheets.

How do the experts do this in Excel?

Thanks!

Boatman
 
B

Bernie Deitrick

Double-click on the fill handle, the little black square on the lower right of the active cell.

HTH,
Bernie
MS Excel MVP
 
B

Boatman

That was easy, Thanks!

Boatman

Bernie Deitrick said:
Double-click on the fill handle, the little black square on the lower
right of the active cell.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
P

Pete

Note, this only works if you have entries in the column you are copying
down or in the column to the left. The technique you described can also
be accomplished in Excel, i.e. move cursor to a column which is full of
entries, press <END> once followed by <DOWN ARROW>, then move across to
the bottom cell of the column you want to copy down. Press a full stop
here, then <END> followed by <UP ARROW>. This will take you to the cell
you want to copy. Click <copy> (or CTRL-C), move down one cell, hold
<SHIFT> down, press <END> followed by <DOWN ARROW>, then release
<SHIFT>, then press <ENTER>. Your formulae will be copied down.

Pete
 
Top