Need Help in numbering cells / auto fill

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 if not let me know
 
R

Ron de Bruin

Hi BostonBeaner

In A1 enter 1
Drag the cell down with the Ctrl key pressed

Do the same for C1
 
G

Gord Dibben

Very rarely will an answer be sent via email.

The general rule is.......posted here, answered here so the entire group can
benefit.

Also, not a good idea to post with a real email address.

The harvesters are working all the time in these news groups.

Gord Dibben Excel MVP
 
Top