If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filling In A Column With Incrementing Values ?
Hello,
Thought I knew how to do this, but apparently I'm doing something wrong. Using Excel 2007 In Column A, Row 1 I have the value "1" I want to drag this box downward to fill in the boxes Below A1, say to A150. But I want each box to increment by the value "1" e.g. A1 would have the 1 A2 would be 2 A3 would be 3 etc. How do I set this up so I can simply "drag" A1 downward to do it ? Thanks, Bob |
#2
|
|||
|
|||
Filling In A Column With Incrementing Values ?
type 1 in a1
type 2 in a2 highlight both cells then click and drag the plus sign in a2 to a150 -- Richard "Bob" wrote: Hello, Thought I knew how to do this, but apparently I'm doing something wrong. Using Excel 2007 In Column A, Row 1 I have the value "1" I want to drag this box downward to fill in the boxes Below A1, say to A150. But I want each box to increment by the value "1" e.g. A1 would have the 1 A2 would be 2 A3 would be 3 etc. How do I set this up so I can simply "drag" A1 downward to do it ? Thanks, Bob . |
#3
|
|||
|
|||
Filling In A Column With Incrementing Values ?
Enter 1 in A1
Right-click on fill handle of A1 and drag down to A150 Release button and "Fill Series" Gord Dibben MS Excel MVP On Sun, 14 Mar 2010 15:43:23 -0400, Bob wrote: Hello, Thought I knew how to do this, but apparently I'm doing something wrong. Using Excel 2007 In Column A, Row 1 I have the value "1" I want to drag this box downward to fill in the boxes Below A1, say to A150. But I want each box to increment by the value "1" e.g. A1 would have the 1 A2 would be 2 A3 would be 3 etc. How do I set this up so I can simply "drag" A1 downward to do it ? Thanks, Bob |
Thread Tools | |
Display Modes | |
|
|