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
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.
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.
Summary: Just a friendly posting tip... A more relevant subject line would have included the word "percentage". If everyone in this forum used subject lines like Excel 2007 Formula Question then figuring out w...
Summary: I made an Excel Spreadsheet that is a list of products, the number of each product, and the value of each. What I want to do is use conditional formatting to highlight the products with the highest v...
Summary: Someone help me using Excel VBAProject to write a formula: Function mySum(firstCell As Range, interval As Integer, lastCell As Range) temp = 0 For i = firstCell.Row To lastCell.Row Step interval tem...