Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
#3
![]() |
|||
|
|||
![]()
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? |
#4
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |