How do i change column headings back to letters in excel?
 

Both the Row and Column headers are numbers, instead of the default letters
for columns and numbers for rows. So instead of having Cell 'A1' for
instance i have Cell 'R1C1'. It makes it confusing when trying to check
correct cells are used in formulas etc. How can i return the column headings
to Letters?

Tools|options|general Tab
uncheck R1C1 Reference style

Chris wrote:

Both the Row and Column headers are numbers, instead of the default letters
for columns and numbers for rows. So instead of having Cell 'A1' for
instance i have Cell 'R1C1'. It makes it confusing when trying to check
correct cells are used in formulas etc. How can i return the column headings
to Letters?

--

Dave Peterson

Go to Tools Options General tab and uncheck "R1C1
reference style".

HTH
Jason
Atlanta, GA

-----Original Message-----
Both the Row and Column headers are numbers, instead of
the default letters
for columns and numbers for rows. So instead of having
Cell 'A1' for
instance i have Cell 'R1C1'. It makes it confusing when
trying to check
correct cells are used in formulas etc. How can i
return the column headings
to Letters?
.