NEED Help With numbering autofill cells

B

BostonBeaner

Ok im having bad day got Drain Bamage

In say colunm A
rows 1 tru 100 I want to number these cells 1 tru 100

in column C
I want to number rows 1 tru 100 as 101 thru 200

by physically typing these numbers in each cell as data.

A1 is 1
A2 is 2


A99 is 99
A100 is 100

C1 is 101
C100 is 200

I know that you can use auto fill or some thing so you
dont have to type each number in.

You first say type in 1 2 3 and then select a range and it
auto fills it.. and inserts 4 thru 100


I hope you can understand this
 
S

swatsp0p

You are sooooo close:

In A1 enter 1
In A2 enter 2
Highlight A1 & A2, click and drag down on the small square in the lower
right of the highlighted area to A100 (note the little reference box that
pops up to show what is being "autofilled" in each cell as you go down).

In C1 enter 101
In C2 enter 102
Repeat from above....

Easy, no?

Bruce
 
B

BostonBeaner

thank you


-----Original Message-----
You are sooooo close:

In A1 enter 1
In A2 enter 2
Highlight A1 & A2, click and drag down on the small square in the lower
right of the highlighted area to A100 (note the little reference box that
pops up to show what is being "autofilled" in each cell as you go down).

In C1 enter 101
In C2 enter 102
Repeat from above....

Easy, no?

Bruce


.
Click to expand...
 
Top