Dragging Groups of Numbers

Q

QVCJDN

I would like to be able to click and drag down a group, or pattern, of
numbers in the same way that you can with letters. In other words, I can
place A, B, and C in consecutive cells, select the three cells, and drag them
down the page - creating A B C A B C A B C, etc. Can this be done with a
pattern of numbers?

Dave
 
G

Gord Dibben

Enter 1,2,3 in A1:A3

Select A1:A3

Right-click on right bottom corner of A3 and drag down column A

Release mouse button and select "copy cells"


Gord Dibben MS Excel MVP
 
Top