While working with a spreadsheet and inserting a new record how can I keep the numbers in seccution like 123 inserting two and still counting correctly. Bill

Quote:

---

Originally Posted by biljacsr

While working with a spreadsheet and inserting a new record how can I keep the the numbers in seccution like 123 inserting two and still counting correctly. Bill

---

If you set up your first column with you "record" number, the you will later be able to sort you records using you record number as a sort criteria.

Hope that helps,
GI Jane 1968

If you are using excel, use this instructions

Select all the cells in the list.

In most cases, you can select one cell and Excel will correctly detect the rest of the list -- but it's not 100% certain. Some of the data may be missed.

Choose Data>Sort

From the Sort by dropdown, select the column you want to sort. Note: If the dropdown is showing Column letters instead of headings, change the setting for My list has, from No header row to Header row.

Select to sort in Ascending or Descending order

Click OK

The CORRECT answer is you can't. If you have 5 records numbered 1-5 and you insert 2 rows after record 2, then you will need to RENUMBER the sequential number column. There are a couple of ways to do this. The first way is to number the first 2 or 3 rows. Then select that range and drag the border down to the bottom of the range of records. Excel will automtically fill in the range with sequential numbers.

The other way is to use a formula for your numbering. In the first row, type in a 1. In the second row (which I will assume is cell A3, Row 1 being the headings and row to the first record) put the formula:

=A2+1

Then copy that formula down the column to the bottom. If you insert some rows within the table, them just copy the formual to the inserted rows. All the formulas will then renumber.