How to get excel row numbers to skip the header

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.

Solution 1:

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

Solution 2:

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.