Procedure to change Column heading from R1C1 to A1?

G

Guest

Tools/Options/General tab/Settings (top-left) untick R1C1 reference style.
HTH, Vote if this helps you solve your problem.
 

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

How do I turn off R1C1 reference type in Excel 2007? 3
Question on this conversion code switching between r1c1 to A1 format tia sal2 2
Newbie question - column letter displayed instead of number 1
Columns are numbers (instead of letters). How to revert? XLS 1
Can I change the column heading from alphabetic to numeric? 2
How do I change excel sheet from R1C1 for cells to A1 for cell? 1
column heading 1
Columns headings have changed to numbers instead of letters 2

Top