Google Product Forums

Re: How do you change a column heading?


MarinusP Jun 21, 2012 12:01 PM
Posted in group: Google Docs

Categories: Sheets : Ask a "how-to" question :

Hi

Op donderdag 21 juni 2012 18:35:46 UTC+2 schreef metarob het volgende:
But why?  Why is Google absolutely insistent that the columns be A, B, C, D, etc?  

The only thing what I can tell you is: What I think why Google wants to use the letters. I thin it is for clearness. If you're searching for cel T275, then you can be pretty sure that it's at the right of S275, and to the left of U275. However, if you are searching for Phone_number275, then it's the question if it's to the right of Street275, Postal_code275, or City275.

But as I said; it is just what I think. I hope for you that Google will answer your question, but, to be honest, I don't expect it.
 
If you freeze the first row, the numbering is off by 1.

And, what's the problem?

=ARRAYFORMULA(ROW(A2:A)-1)