Column Headings

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
 
N

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top