Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to make the columns be from 1 to 195, in order from least to greatest, so that if I make a mistake (say, I want to add an entry between row 28 and 29), I want Excel to order itself from 1 to 196.

Example:

1
2
3
4
5
6
__ I want to insert a new row here
7
8

and so on...

Excel aligns itself to:

1
2
3
4
5
6
7 (The new row)
8
9

and so on...

Is there a function in Excel that allows me to do this?

What I mean is there's a column with numbers. How do I organize them in increasing order, so that if a row was added, the numbers would shift down into the next row and the numbers for that column would be in an increasing order?

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

It isn't entirely clear what you are after, but if you want a cell containing a number dependent on its row, then use the

=row()

funtion. If you insert a row, then this will automatically increment the numbers in the rows after the insert.

share|improve this answer
    
that's what I want. Is there a button for this? –  romastanas13 Nov 11 '11 at 0:23
    
Just type it into a cell exactly as above –  Paul Nov 11 '11 at 0:25
    
No, what I mean is there's a column with numbers. How do I organize them in increasing order, so that if a row was added, the numbers would shift down into the next row and the numbers for that column would be in an increasing order? –  romastanas13 Nov 11 '11 at 0:30
2  
Put =row() into each row instead of putting numbers in. –  Paul Nov 11 '11 at 0:35
add comment

I think you want to make a table. Then just have the column sort ascending. It won't do it automatically though. After you enter in a bunch of cells in that column, you'll have to tell Excel to sort ascending again.

Or you could just select the column and click Data, then Sort.

But then again, that's isn't what a spreadsheet is for.

What are you trying to create? What's the final result?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.