Tools|options|General Tab
Uncheck R1C1 Reference Style.

JBC10094 wrote:

In Excel 97, both my column and row headers are displayed as numbers, how do
I restore my settings to have numbers on the rows and letters on the columns
?.

--

Dave Peterson