Changing the incrementation when "puliing" cell values down a colu

M

Matt G

I have a column formatted as text. In cell A1 i type "2". When I grab the
corner of the cell and "pull" down the cells below are populated increasing
by 1. Can I change the increment? I'd like it increase by a value of 10
each cell.
 
M

Matt G

That populates every other cell but the numbers still only increases by an
increment of one per cell populated a1=12 a3=13, etc. What I would like to
do is populate cell a1 with "10" and pull down and have a2 = "20" a3 = "30",
etc.

Is that possible?
 
S

shg

You can enter 10 in A1, select the range of interest (including A1), and
do Edit > Fill > Series, and follow instructions from there.
 
G

Gord Dibben

Enter 10 in A1, 20 in A2.

Select both and right-click and drag down.

Release button and "Fill Series"

Will work for either text or numerics.


Gord Dibben MS Excel MVP
 
M

Matt G

Works great thanks for the help!

Gord Dibben said:
Enter 10 in A1, 20 in A2.

Select both and right-click and drag down.

Release button and "Fill Series"

Will work for either text or numerics.


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting a range to a single cell 0
Adding cells until they are greater than a lookup cell and returning a value 1
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Dragging values down a range using a colum to determine its length 4
Am trying to autofill a formula and it will not increment down? 1
change cell contents when pull down menu choices change 3
Formatted cell column in drop down list 1
Auto Fill function in Excel 2007 not working properly 4

Top