Column caption

[Magne Ryholt]

Is there any way to (programatically) give the column headers other caption
text than the standard A,B,C... or 1,2,3... ?
Formula or programatic reference must of course still work.

 

[Harald Staff]

Hei Magne

That is unfortunately not possible. The usual workaround is to hide them,
freeze row 1, maybe also column A, and decorate like desired headers.

 

[David McRitchie]

and if you want to see simulated row numbers
=ROW() + 1
but you will have to use the actually row numbers in your
formulas.