Excel 2007 change column labels from numbers to letters


V

Victoriah

I am working in Excel 2007. Currently the column labels are showing up as
numbers naming cells as R1C1 etc. I'd much rather use letters for the
column labels so the cells will be the usual A1, B2 etc. I've searched the
help menus and have been unable to find out how to do this.
 
Ad

Advertisements

R

Ron de Bruin

Office Button>Excel Options

On the Formulas tab check or uncheck R1C1 reference................
 
S

Susan

Ron

I am having same problem and I read your reply and can't fiure out what you
mean. Can you help me too?

Susan
 
R

Ron de Bruin

Hi Susan

The Office Button is the big round circle next to the Home tab on the ribbon.
Click on it and you see a "Excel Options" button.

Click on Formulas and uncheck the R1C1 option in the "working with formulas" section
 
S

Susan

Yikes - I'm no programmer - I'm sorry - can you explain where this "Home" tab
and ribbon are? Is this Visual Basic?
 
Ad

Advertisements

S

Susan

I figured out! Thanks!

Ron de Bruin said:
Hi Susan

The Office Button is the big round circle next to the Home tab on the ribbon.
Click on it and you see a "Excel Options" button.

Click on Formulas and uncheck the R1C1 option in the "working with formulas" section
 
Ad

Advertisements


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

Top