Column Headings

G

Guest

How do I get the column headings to show A,B,C,D,E,F,G etc as they have
changed and are showing numbers 1,2,3,4,5,6,7 instead. Hence a cell
reference of A1 is R1C1 (Row 1 Column1)
 
G

Guest

Click TOOLS in the menu, selection OPTIONS and then click on the GENERAL tab.
Turn off the R1C1 notation by clicking the R1C1 reference style check box
 

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

Column headings display as a numbers 7
How can I change column titles back to numbers? 4
column headings 3
Why are my column headings numerical instead of alphabetical? 1
Hidden Columns and Row Headings 3
Excel Column Headings Numeric to Alpha 1
Column headings - urgent help needed please 3
Having Blank Cells, etc. ? 1

Top