Alpha column lables

O

Oly User

My new Excel 2007 worksheets are opening with numerical lables on the rows
and columns. I have not been able to figure out how to change the column
lables to alpha characters. Any one able to help?
Thanks.
 
R

Reitanos

It is an option called R1C1 Reference Style. You'll have to turn it
off by going to the Office logo button and changing Excel's options.
 
O

Oly User

Thank you!!!

Reitanos said:
It is an option called R1C1 Reference Style. You'll have to turn it
off by going to the Office logo button and changing Excel's options.
Click to expand...
 

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

Need help removing extra TOC text from number lists used as TOC levels 0
Hyperlinks with lookups 0
Need Help with a VBA subroutine 0
Setting a range in a named range 3
Excel 2007 PivotTables 1
Track Changes change in display 0
how to print lables from worksheet? 2
Setting column width in a table with a macro is not working 0

Top