| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheet with numbers as column & row headers - How?
I received an excel spreadsheet that has numbers as column headers (instead
of letters) and numbers as row headers. How do you change the headers for the columns and rows. I always thought they were set. I have looked and looked and can't find any information on this. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet with numbers as column & row headers - How?
Probably this way:
Toolsoptionsgeneral deselect R1C1 reference style Regards, Fred "cg-ksd" wrote in message ... I received an excel spreadsheet that has numbers as column headers (instead of letters) and numbers as row headers. How do you change the headers for the columns and rows. I always thought they were set. I have looked and looked and can't find any information on this. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet with numbers as column & row headers - How?
hi
on the menu bartoolsoptionsgeneral tabuncheck R1C1 reference style. Regards FSt1 "cg-ksd" wrote: I received an excel spreadsheet that has numbers as column headers (instead of letters) and numbers as row headers. How do you change the headers for the columns and rows. I always thought they were set. I have looked and looked and can't find any information on this. Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet with numbers as column & row headers - How?
In case you're using Excel 2007
Office ButtonExcel OptionsFormulas. Uncheck R1C1 notation. Gord Dibben MS Excel MVP On Mon, 14 Dec 2009 12:28:01 -0800, cg-ksd wrote: I received an excel spreadsheet that has numbers as column headers (instead of letters) and numbers as row headers. How do you change the headers for the columns and rows. I always thought they were set. I have looked and looked and can't find any information on this. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why did my Excel column headers change from letters to numbers? | Excel Discussion (Misc queries) | |||
| For Excel 2007 how do yu change column headers from numbers to let | Excel Discussion (Misc queries) | |||
| In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
| Change Excel column headers from numbers to letters | Excel Discussion (Misc queries) | |||
| My Excel column headers have changed to numbers, how do I get bac. | Excel Discussion (Misc queries) | |||
Hybrid Mode
