Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 switching automatically.
The excell spreadsheet starts off with having Letters A,B,C at the top row.
After clicking on numerous random cells then change to numbers 1,2,3. Simply clicking R1C1 settings does not help the situation. I believe I need to use a macro to force the row to stay as Letters A,B,C. What macro could you suggest for this? Or if there is another idea please let me know. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 switching automatically.
It sounds as if you need to find the macro that is changing it *to* R1C1,
and then disable that unwanted feature. -- David Biddulph "essential" wrote in message ... The excell spreadsheet starts off with having Letters A,B,C at the top row. After clicking on numerous random cells then change to numbers 1,2,3. Simply clicking R1C1 settings does not help the situation. I believe I need to use a macro to force the row to stay as Letters A,B,C. What macro could you suggest for this? Or if there is another idea please let me know. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 switching automatically.
There are no macros enabled on this excell worksheet. It doesn't happen with
any other worksheest created by this issue of Microsoft Excell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Discussion (Misc queries) | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
Automatically switching between worksheets. | Excel Discussion (Misc queries) |