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

Descenders clipped 0
Style Gallery View 3
How do I remove the top half of a block interval? 1
Slideshow with black border around it 0
Problem with SET & REF function 0
Setting column width in a table with a macro is not working 0
Countdown macro - display settings 2
How do I convert numbered columns to lettered columns? 1

Top