| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find alpha in column 1 numeric column 2 | Excel Discussion (Misc queries) | |||
| Alpha column references | Excel Discussion (Misc queries) | |||
| Alpha column references | Excel Discussion (Misc queries) | |||
| alpha column changed to numerical column | New Users to Excel | |||
| HELP w/ column Alpha | Excel Discussion (Misc queries) | |||
Hybrid Mode
