Column Headings

  • Thread starter Thread starter RFJ
  • Start date Start date
R

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