Column headers numbers instead of letters
 

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?
--
Hursh

Column headers numbers instead of letters
 

In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK out

Other versions of Excel:

ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK out

--
Biff
Microsoft Excel MVP


"Hursh" wrote in message
...
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?
--
Hursh

Column headers numbers instead of letters
 

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

"Hursh" wrote:

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?
--
Hursh