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
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 quot;copy cellsquot;Gord Dibben MS Excel MVP
On Tue, 2 May 2006 07:30:02 -0700, QVCJDN gt;
wrote:
gt;I would like to be able to click and drag down a group, or pattern, of
gt;numbers in the same way that you can with letters. In other words, I can
gt;place A, B, and C in consecutive cells, select the three cells, and drag them
gt;down the page - creating A B C A B C A B C, etc. Can this be done with a
gt;pattern of numbers?
gt;
gt;Dave
- Apr 21 Sat 2007 20:36
Dragging Groups of Numbers
close
全站熱搜
留言列表
發表留言