R1C1 switching automatically.

E

essential

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.
 
D

David Biddulph

It sounds as if you need to find the macro that is changing it *to* R1C1,
and then disable that unwanted feature.
 
E

essential

There are no macros enabled on this excell worksheet. It doesn't happen with
any other worksheest created by this issue of Microsoft Excell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Questions: R1C1 and stop text number converting to data 5
R1C1 settings auto changing 5
new workbook format is in reverse 3
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Doesn't it make you mad?? 9
Convert text to number automatically 1
Use index function to return formula 3
MACRO RUN random percentage and copy of column values 1

Top