Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question on this conversion code switching between r1c1 to A1 format tia sal2 temp Excel Worksheet Functions 1 September 16th 07 06:54 AM
Question on this conversion code switching between r1c1 to A1 format tia sal2 temp Excel Discussion (Misc queries) 2 September 14th 07 08:58 PM
Question on this conversion code switching between r1c1 to A1 format tia sal2 temp Excel Worksheet Functions 2 September 14th 07 08:58 PM
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 temp Excel Discussion (Misc queries) 3 September 13th 07 08:31 AM
Automatically switching between worksheets. dinouk Excel Discussion (Misc queries) 3 December 6th 06 10:08 PM


All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"