Ask Experts Questions for FREE Help !
Ask
    biljacsr's Avatar
    biljacsr Posts: 1, Reputation: 1
    New Member
     
    #1

    Jul 18, 2007, 09:07 PM
    Inserting records
    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
    GIJane1968's Avatar
    GIJane1968 Posts: 7, Reputation: 1
    New Member
     
    #2

    Jul 18, 2007, 09:41 PM
    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
    benn11's Avatar
    benn11 Posts: 1,036, Reputation: 43
    Ultra Member
     
    #3

    Jul 19, 2007, 04:12 AM
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #4

    Jul 19, 2007, 06:31 AM
    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Inserting Flash Video into Website [ 4 Answers ]

Hello, I need to insert flash video into a website (we are converting from Windows Media video - much faster and dependable format). I have the video converted, uploaded, and linked on the website. I want to know how to turn on the little button controls for the player. Right now, the clip...

Inserting a row in Excel [ 3 Answers ]

I am trying to insert a row and keep getting this error message that it cannot shift non blank cells off worksheet. I have never seen this before and never had a problem inserting a row, what do I do.

Inserting multiple columns on Excel [ 2 Answers ]

Can anyone help me to insert multiple columns under any particular cell without disturbing other cell data ? For example it should be like : --------------------------------------------------------- | A | B | C |...


View more questions Search