Begin Excel row numbering with "0"

jmt356
SilverLounger
Posts: 2392
Joined: 28 Mar 2010, 01:49

Begin Excel row numbering with "0"

Post by jmt356 »

In any new Excel spreadsheet, the rows come automatically numbered as follows: 1, 2, 3, etc. Is it possible to start the numbering from 0 or to otherwise prevent Excel from numbering the first row? The first row in my document contains headers and I want the number 1 to correspond to the actual contents of the spreadsheet rather than to the header.
Regards,

JMT

User avatar
HansV
Administrator
Posts: 78629
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Begin Excel row numbering with "0"

Post by HansV »

No, that is not possible. The numbering of the rows is fixed.

And before you ask: it isn't possible to change the column letters either.
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Begin Excel row numbering with "0"

Post by Rudi »

...except if you switch to R1C1 notation. :evilgrin:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78629
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Begin Excel row numbering with "0"

Post by HansV »

But if you do, the column numbering will start at 1; it is not possible to change that.
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Begin Excel row numbering with "0"

Post by Rudi »

You're being too exact again Hans; my evil grin was just referring simply to A,B,C's becoming 1,2,3's. :cheers:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.