ExcelBanter - Alpha column lables

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Alpha column lables (https://www.excelbanter.com/excel-worksheet-functions/189264-alpha-column-lables.html)

Oly User

Alpha column lables

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.

Reitanos

Alpha column lables

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.

On May 29, 11:10 am, Oly User <Oly
wrote:
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.

Oly User[_2_]

Alpha column lables

Thank you!!!

"Reitanos" wrote:

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.

On May 29, 11:10 am, Oly User <Oly
wrote:
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.

All times are GMT +1. The time now is 08:56 PM.