change excel column headings from numeric to alphabetical

E

Erasmus

All worksheets in my version of Excel (2003) show column headings as numbers
rather than letters. Without alphabetic headings it's impossible to identify
specific cells, needed when working with formulae for instance.
 
P

Peo Sjoblom

Tools>options>general uncheck R1C1 reference style

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

How: reset the column headings from numeric to alphabetic? 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Can I change the column heading from alphabetic to numeric? 2
Lookup all occurences and return their column headings 5
Excel does not accept text format! 0
How do I change excel column heading from numeric to alphabetic? 2
Merging from an Excel file with graphics 1
EXCEL ALPHABETICAL COLUMN HEADINGS 2

Top