automatic numbering of rows in excel, how to?

L

Linda C.

How can I set up the first column to automatically number each row as I go
down a list in excel?
Office 2000
 
D

Don

Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down.

=IF(ISNUMBER(B1),ROW(),"")


If data are text then substatute ISTEXT for ISNUMBER

Don Pistulka
 
S

Six Sigma Blackbelt

What I need
excel to do, is to insert numerical numbering into the cells starting at A19,
the formula in B15 multiples B9, B10 and B13, so whatever is the sum of B15,
I need Excel to start inserting numbers numerically at cell A19 to whatever
the sum of B15 is, so if B15 is 30, I need 1 thur 30 inserted starting at A19
thru A49.

Thanks MJS
 
S

Spiky

Put in:
A19: 1
A20: =IF(A19+1>B15,"",A19+1)
Copy to A21 and down as far as you will ever need to go. You may want
to alter your print settings after this so it doesn't print the blank
cells.
 
S

Spiky

Put in:
A19: 1
A20: =IF(A19+1>B15,"",A19+1)
Copy to A21 and down as far as you will ever need to go. You may want
to alter your print settings after this so it doesn't print the blank
cells.
Click to expand...

Oops. One change:
A20: =IF(A19+1>$B$15,"",A19+1)
 
R

Robi

Hi I'm using excel 2007 ..

I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"")

but for numbers it is working =IF(ISNUMBER(B1),ROW(),"")

is there anything different for 2007
 
P

Peo Sjoblom

It certainly works for me, once can of course change it to either text or
numbers

=IF(LEN(B1)>0,ROW(),"")



--


Regards,


Peo Sjoblom
 
R

Robi

Thank you Peo Sjoblm

every code is working for me.. =IF(LEN(B1)>0,ROW(),"")

can help me to say how to add auto number of rows by selecting some rows
which I need to number.. I've 6000 rows.. But they will be numbered by
selecting 200 rows or 300 rows. After 200 they will be counted or number from
1. Is there any way cell selection with mouse and number them?
 

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

Merging from an Excel file with graphics 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Mail Merge Directory Conditional Page Break 0
MS Project Center-Autolink column fields 0
How to make repeating drop-down lists? 2
Paragraph numbering in Word 1
Excel does not accept text format! 0
Integrating information from Word to Excel (not mail merge) 1

Top