Excel columns

E

Excel 2007 columns

When i open excel Sheet the columns instead of having alphabets like
(A,B,C,D.... ) it has numbers 1,2,3,4...... . How should i change the
columns numbers to alphbets
 
G

Gord Dibben

Office Button>Excel Options>Formulas.

Uncheck R1C1 reference style.


Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 01:05:02 -0700, Excel 2007 columns <Excel 2007
 

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 to mention rows in alphetical format instea dof numbers 2
Setting column width in a table with a macro is not working 0
Cell data entering slow! 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Track Changes change in display 0
Found few bugs in my daily routine of work in excel for MAC 0
Adding sequence numbers to paragraphs 0
Date diffrence in days, weeks and months. 1

Top