ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel, COLUMN HEADERS ARE NUMERICAL (https://www.excelbanter.com/excel-discussion-misc-queries/2469-excel-column-headers-numerical.html)

dstach11

In Excel, COLUMN HEADERS ARE NUMERICAL
 
I don't know what I've done, but my columns are numerical 1, 2, 3, etc not
the typical Column A, B, C. Also, my functions all read something like this:
R[-1]C+R[24]C[2]

How can I get my spreadsheets back to normal?

Don Guillett

toolsoptionsgeneralr1c1

--
Don Guillett
SalesAid Software

"dstach11" wrote in message
...
I don't know what I've done, but my columns are numerical 1, 2, 3, etc not
the typical Column A, B, C. Also, my functions all read something like

this:
R[-1]C+R[24]C[2]

How can I get my spreadsheets back to normal?




Frank Kabel

Hi
goto 'Tools - Options - General' and uncheck 'R1C1 reference style'

--
Regards
Frank Kabel
Frankfurt, Germany

dstach11 wrote:
I don't know what I've done, but my columns are numerical 1, 2, 3,
etc not the typical Column A, B, C. Also, my functions all read
something like this: R[-1]C+R[24]C[2]

How can I get my spreadsheets back to normal?




Peo Sjoblom

Toolsoptionsgeneral uncheck R1C1 reference style


Regards,

Peo Sjoblom

"dstach11" wrote:

I don't know what I've done, but my columns are numerical 1, 2, 3, etc not
the typical Column A, B, C. Also, my functions all read something like this:
R[-1]C+R[24]C[2]

How can I get my spreadsheets back to normal?



All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com