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.
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
This formula worked for me. I inserted a new column for A in my spreadsheet, then used this formula in cell A2:
=ROW(2:2)-1
Then I went to "Page Layout" to uncheck View Headings, as discussed in previous answers.
This formula keeps the row numbers accurate when sorting, and does not count the first row for the headings.
Old-fashioned I know, but I just used the "row" function and added minus 1: (A2:A93)- 1
that's worked for numbering my rows anyway!
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
I made my left hand column start with one as number one of the actual first row. Then I unchecked the 'view headings' box in the page layout view. That took out the left hand auto numbered column and the ABC etc out of the header.
cl
