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.

in cell A2, type 12. Highlight A1 AND A2, drag down.

"Matt G" wrote:

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.

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?

"Sean Timmons" wrote:

in cell A2, type 12. Highlight A1 AND A2, drag down.

"Matt G" wrote:

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.

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


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=2636

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

On Mon, 3 Nov 2008 06:00:01 -0800, Matt G
wrote:

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?

"Sean Timmons" wrote:

in cell A2, type 12. Highlight A1 AND A2, drag down.

"Matt G" wrote:

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.

Works great thanks for the help!

"Gord Dibben" wrote:

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

On Mon, 3 Nov 2008 06:00:01 -0800, Matt G
wrote:

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?

"Sean Timmons" wrote:

in cell A2, type 12. Highlight A1 AND A2, drag down.

"Matt G" wrote:

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.