Column Headings

[RFJ]

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

 

[Niek Otten]

Hi Rob,

Tools>Options>General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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