Column Headings Have Changed--HELP!!!

JazzyJen

New Member
Joined
Apr 11, 2002
Messages
23
We have opened up a workbook and the column headings that are normally titled by letters are now titled by numbers. The cell address for cell A1 now reads something like (R1)....I don't know what happened, but now all my workbooks have numbers for column headings, but the formulas seem to be working fine.....help please.....
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Paul B

Well-known Member
Joined
Feb 15, 2002
Messages
575
Go to tools options, general and uncheck R1C1 reference style
 

JazzyJen

New Member
Joined
Apr 11, 2002
Messages
23
Thank you for helping me with the column heading mystery.....thank goodness I have the Excel board when I am out of answers!
You are live savers!!!!--Jen
 

Forum statistics

Threads
1,148,144
Messages
5,745,044
Members
423,917
Latest member
Frank1931

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top