how do I change cell labelling from R1C1 to A1?

G

Guest

My excell is now labelling rows and columns as numbers. Instead of having
letters in the columns as usual, I prefer to say B4 when calling a cell than
R4C2. How can I change that?

thanks
 
G

Guest

Click TOOLS/OPTIONS on the menu and select the GENERAL tab. Remove the check
mark from R1C1 REFERENCE STYLE the first check box on the left side of the
tab page.
 

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 change default cell referencing in excel from R1C1 to A1? 1
Column headers numbers instead of letters 2
R1C1 switching automatically. 2
r1c1 reference style - how to make it default 4
How can I change column designation from number to letters? 3
Cell References Format 2
Columns now numbers rather than letters how do i get letters back 2
How can I change column titles back to numbers? 4

Top