Column headers numbers instead of letters

H

Hursh

someone sent me an excel file with the columns labeled as numbers instead of
letters, so cell A1 shows up as R1C1. Now every file I open has this format.
Can someone please help me change it back to normal?
 
T

T. Valko

In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK out

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK out
 
M

Mike H

Hi,

Excel remembers the first file you open in a session and keeps that
reference method.

Tools|options - general tab and un-check R1C1

Mike
 

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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Column header format 5
Excel sheet with numbers as column & row headers - How? 3
Columns are numbers instead of letters 4
why are my column headers numbers instead of letters? 2
Why are column headings numbers instead of letters? 1
column headers changed from letters to numbers, how do I change ba 1
Change Excel column headers from numbers to letters 1

Top