Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging Groups of Numbers
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging Groups of Numbers
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 On Tue, 2 May 2006 07:30:02 -0700, QVCJDN wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
Dealing with worksheet groups | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |