Column Headings
 

I've received a spreadsheet from someone where both row and column headings
are numeric.

How can I change this spreadsheet back to the default of alpha column
headings and numeric row headings.

I'm using XL2007

TIA

Rob

Column Headings
 

Hi Rob,

ToolsOptionsGeneral tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"RFJ" wrote in message ...
| I've received a spreadsheet from someone where both row and column headings
| are numeric.
|
| How can I change this spreadsheet back to the default of alpha column
| headings and numeric row headings.
|
| I'm using XL2007
|
| TIA
|
| Rob
|
|