columns appear as numbers not letters
 

i have just opened a spreadsheet in excel, and rather than the columns
showing as A B C they are showing the same as rows, in numbers 1 2 3. This is
not normal and i can't write formulas.

columns appear as numbers not letters
 

Hi Clairey

ToolsOptionsGeneral unclick R1C1 referencing

--
Regards

Roger Govier


"Clairey" wrote in message
...
i have just opened a spreadsheet in excel, and rather than the columns
showing as A B C they are showing the same as rows, in numbers 1 2 3.
This is
not normal and i can't write formulas.

columns appear as numbers not letters
 

go to Tools Options General tab under Settings uncheck R1C1
reference style.

Clairey Wrote:
i have just opened a spreadsheet in excel, and rather than the columns
showing as A B C they are showing the same as rows, in numbers 1 2 3.
This is
not normal and i can't write formulas.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=557245