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.

How can I find out the row number in an Excel spreadsheet?

share|improve this question

migrated from stackoverflow.com Oct 12 '09 at 12:02

This question came from our site for professional and enthusiast programmers.

    
By formula, try Row() –  Richard Morgan Oct 12 '09 at 12:05
    
Could you offer us a bit more information into what you want to achieve? –  alex Oct 12 '09 at 12:13

1 Answer 1

ROW(C5) gives the row number of cell C5, ie 5. This can be useful for making sure that you have a fixed starting point for some other function like an OFFSET. If someone adds or deletes rows which affect that C5 cell, your formula would update to C4, C6 or whatever, and you still have a correct starting row.

ROW() gives the row number of the cell you use that formula in. I often use this with the MOD function in conditional formats to stripe sets of rows, or underline every 5th one say to make it easier to follow rows across a printed page.

share|improve this answer

Your Answer

 
discard

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