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.

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). In the attached screenshot socks is row one but since the header is counted it has become row two.

enter image description here

share|improve this question

migrated from stackoverflow.com Sep 28 '12 at 12:42

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

    
This functionality is unlikely to have in Excel, IMO. It could only eventually create problems for less experienced users without adding a great payback value. –  Tiago Cardoso Aug 1 '11 at 22:52
    
@Issun, Dont think in terms of List starting at A2. In 99% of cases the first line in excel is always the header. Items starts from A2 so ideally MS should provide some checkbox option somewhere that says something like "First row is header" which will put rows numbers starting with one from A2 row.. thanks –  Gullu Aug 2 '11 at 2:35
    
@Gullu, I'm not sure about your 99% percent of headers in row 1... I'd say that I've seen many spreadsheets with headers coming into rows 2 or 3, keeping row 1 as padding. Again, there's no rule about row 1 contain in 99% of cases a header. Please, feel free to prove us we're wrong. –  Tiago Cardoso Aug 2 '11 at 3:03
    
@Tiago, As I stated in my question this is really a cosmetic issue. If multiple lines span the header dont you think it makes sense to have some input in options which says "enter no of lines in header" which will put row numbers starting at one skipping header lines. I know there is no such thing and looking for a trick or hack if someone has done it before. thx –  Gullu Aug 2 '11 at 13:03
    
ok. Never used superuser. Will look into that site. Moderator please delete this question if you think it is useless. thanks –  Gullu Aug 19 '11 at 13:03
show 1 more comment

2 Answers

up vote 2 down vote accepted

Simply put, the answer is no; that feature does not exist in Excel.

If you needed it for some reason, you could easily implement your own ID column and populate the cells with the numbers you want represented.

Like so:

Id  Description
1   Socks
2   Boxers
3   Shoes

Then, you simply removing the column and row headings. That way you get the illusion that the rows are starting with your data.

Just a thought.

-Justin

share|improve this answer
    
Nice idea. thanks –  Gullu Aug 19 '11 at 13:02
add comment

I just tried to perform this and this is the first forum I came across after searching "microsoft excel how to start row numbers from a different row" in Google. This might be what you're after, which is acceptable for my spreadsheet for personal use.

Basically, I doubled the row hight of the first row and ticked the box "wrap text" in format options for my used cells in the first row. I then entered spaces after the word which I wanted to be the header for each column so they dropped down to the second line (sitting below my title text) and made them bold and underlined like your example. The result was the row number sat in-line with the second line of text in the first row cells, in your case, "Socks". All that is missing is a cell number and gridline but the result is almost there. Adam

share|improve this answer
1  
So, if I enter =A2 and =B2 somewhere else in the sheet, I will get Pants and 2, but if I enter =A1 and =B1, I will get Description (newline) Socks and Quantity (newline) 3? This would break the spreadsheet if it is used as a spreadsheet, rather than just a text file that happens to have rows and columns. –  Scott Mar 12 '13 at 18:42
    
Yes, hence why I stated it is just a quick fix and only acceptable, in my case, for personal use. –  Adam Mar 12 '13 at 18:50
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.