Computing.Net > Forums > Office Software > excel numbering formula

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

excel numbering formula

Reply to Message Icon

Name: greenbear
Date: August 25, 2004 at 07:30:24 Pacific
OS: xp home
CPU/Ram: pent 4
Comment:

Hey all,

I am using excel 2000 and I need to number rows from 1- 10,000 or so. I know I could use the sum() or count() functions in the first cell and drag it down, but I was wondering if there was instead one formula I could enter tha would automatically number the rows for me.

thanks



Sponsored Link
Ads by Google

Response Number 1
Name: Mark Long
Date: August 25, 2004 at 08:24:40 Pacific
Reply:

Click in the column header you want to display the numbers and you will see the column highlighted. Then go to Edit > Fill > Series and enter the start & stop values.

Regards

M


0
Reply to Message Icon

Related Posts

See More


Works to Word.doc MS Access dbms??



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: excel numbering formula

Excel 2007 Formula Question www.computing.net/answers/office/excel-2007-formula-question/9280.html

Excel Spreadsheet Formula www.computing.net/answers/office/excel-spreadsheet-formula/9360.html

Excel VB formula not auto update www.computing.net/answers/office/excel-vb-formula-not-auto-update/5582.html