Excel 97 Column & Row Header Problem
 

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

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

Go to Tools, Options, General, and deselect R1C1 tickbox.

"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
?.