Change Excel column headers from numbers to letters
 

I received an Excel file from another user. All of the column headers are
numbers rather than letters and all formulae cell references are relative
rather than absolute. How do I change back to the standard letter column
header and absolute cell address?

Thanks for the help,

Change Excel column headers from numbers to letters
 

Tools|Options|general

Uncheck R1C1


Mike

"Dave" wrote:

I received an Excel file from another user. All of the column headers are
numbers rather than letters and all formulae cell references are relative
rather than absolute. How do I change back to the standard letter column
header and absolute cell address?

Thanks for the help,