Cells display as R5C5. How do I change it to display E5?

F

FinanceTrainer

The default rows and columns on Excel are both displayed in numbers. How do
I change the Columns to display the letters of the alphabet as it did on on
Excel 2003?
 
×

מיכ×ל (מיקי) ×בידן

Tools > Options > General > cancel the Reference R1C1 optiion.
Micky
 

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 do I convert numbered columns to lettered columns? 1
Columns are numbers instead of letters 4
My Column display as "numbers" instead of "alphabets" 1
Column header format 5
problem in Excell 2003 4
column headers changed from letters to numbers, how do I change ba 1
Excel sheet with numbers as column & row headers - How? 3
Ribbon Display Options askew?? 6

Top