Need Help in numbering cells / auto fill

  • Thread starter Thread starter BostonBeaner
  • Start date Start date
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
 
Hi BostonBeaner

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

Do the same for C1
 
Whoops sorry I didnt list my email or you can reply here
thank you
 
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
 
You must log in or register to reply here.

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

NEED Help With numbering autofill cells 3
conditional formatting 8
Auto Fill - cell numbering patterns 3
Calculate (Auto Fill) cells with numbers and text. 3
DCOUNT Help! 1
Auto fill/list 1
Auto fill numbers starting with zero 3
Auto Fill Cell 1

Back
Top