| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel shows numbered column headers.
My spreadsheet shows numbered row headers and numbered column headers. I
want to change the column headers to letters but do not know how. Need help please. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows numbered column headers.
hi
on the menu bar... Toolsoptionsgeneral tabuncheck R1C1 reference style Regards FSt1 "Mike Blum" wrote: My spreadsheet shows numbered row headers and numbered column headers. I want to change the column headers to letters but do not know how. Need help please. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows numbered column headers.
Excel 2003 and earlier.
ToolsOptionsGeneral. Uncheck "R1C1 Reference Style" Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 17:21:02 -0700, Mike Blum wrote: My spreadsheet shows numbered row headers and numbered column headers. I want to change the column headers to letters but do not know how. Need help please. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows numbered column headers.
That did the trick. Thank you very much for your help.
"FSt1" wrote: hi on the menu bar... Toolsoptionsgeneral tabuncheck R1C1 reference style Regards FSt1 "Mike Blum" wrote: My spreadsheet shows numbered row headers and numbered column headers. I want to change the column headers to letters but do not know how. Need help please. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows numbered column headers.
Thank you very much for the help. Mike
"Gord Dibben" wrote: Excel 2003 and earlier. ToolsOptionsGeneral. Uncheck "R1C1 Reference Style" Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 17:21:02 -0700, Mike Blum wrote: My spreadsheet shows numbered row headers and numbered column headers. I want to change the column headers to letters but do not know how. Need help please. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create numbered sortable numbered list in excel | Excel Discussion (Misc queries) | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| Excel column headers | Excel Discussion (Misc queries) | |||
| how does excel read only odd numbered rows of data froma column? | Excel Worksheet Functions | |||
| Excel column/row headers | Excel Worksheet Functions | |||
Linear Mode
