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

VBA - exporting serial letters to single documents 0
Setting column width in a table with a macro is not working 0
Problem with SET & REF function 0
why are my column headers numbers instead of letters? 2
Access Lock File .LACCDB / Now shows as a notepad file 0
Column header format 5
How to rename the head A,B,C,D,E etc. on every column 0
Embedded Excel into Word with Tables 0

Top