change column name from 1 2 3 to A B C in Excel 2007

A

Ahmad Sanad

Hi All

when I open new Excel file the column name is 1 2 3 and the Row name als 1 2
3 how can I chane back the column name to A B C

Many thanks
Ahmad
 
D

Dave Curtis

Hi,

In Excel2003 and earlier, go to Tools>Options>General and uncheck the R1C1
box.

In Excel2007, you'll have to wait for someone else to comment.

Dave
 
A

AnotherNewGuy

Click the Office button -- upper left
Excel options
Formulas
Uncheck R1C1 reference style
 

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

Change column Name from 1 2 3 to A B C in excel 2007 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Name of file opened, being viewed 2
Merging from an Excel file with graphics 1
Adding sequence numbers to paragraphs 0
Insert name and adress from a list in a word document 1
Need some PWA help 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top