![]() |
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? |
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? |
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? |
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