How do I change my column headings from numbers to alpha

R

Ragman

My column headings have suddenly become numbers instead od lettters. How do
I change tehm back to letters?
 
G

Gord Dibben

Tools>Options>General.

Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP
 

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

Similar Threads

Excel 2007... fix column headings from numbers back to letters 2
Need help modifying code 0
How do I change headings (column name) from numbers to letters? 2
Column Heading 1
column headings 3
Column Heading Error 3
why have my column headings changed to numbers 1
Changing grey column headings from numbers back to capital letters 2

Top