EXCEL QUESTION

[brunell8]

This is probably simple, but I don't know how to do it. I've got a simple spreadsheet in Excel 2000 with it consisting of a list of 2566 different items. I have the first column numbered accordingly. What I need to be able to do is say I delete lines 5 and 1000, I want every line to renumber so that it would now show 2564 items. Can this be done or would I have to renumber the whole column (by dragging the cross, not typing in each number)?

 

[FoolishMcNasty]

thats a good question...you would probably have to use/write a macro...

try this forum, it might be able to help you...Mr. Excel

 

[kranky]

Assuming you start on row 1, use the formula =ROW() in the cell where you want the row number displayed. It will self-adjust as you delete and insert rows.

If you start at row 3, for example, and want the rows numbered starting with 1, use the formula =ROW()-2 instead.

 

[brunell8]

Thanks for the help. Got the same answer on Mr. Excel. Worked like a charm!