| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Heading Error
Typically the row heading on worksheets are numbers and the column heading
are letters. For what ever reason, my worksheet is displaying both the row and column headings as numbers. It is very difficult to create formulas when their are two sets of numbers. How do I change the column heading to be letters? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Heading Error
From menu ToolsOptionsGeneral uncheck 'R1C1 reference style'
If this post helps click Yes --------------- Jacob Skaria "Gunther" wrote: Typically the row heading on worksheets are numbers and the column heading are letters. For what ever reason, my worksheet is displaying both the row and column headings as numbers. It is very difficult to create formulas when their are two sets of numbers. How do I change the column heading to be letters? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Heading Error
Tools Options General R1 C1 (Uncheck)
HTH Regards, Howard "Gunther" wrote in message ... Typically the row heading on worksheets are numbers and the column heading are letters. For what ever reason, my worksheet is displaying both the row and column headings as numbers. It is very difficult to create formulas when their are two sets of numbers. How do I change the column heading to be letters? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Heading Error
Thanks for the help!
"Jacob Skaria" wrote: From menu ToolsOptionsGeneral uncheck 'R1C1 reference style' If this post helps click Yes --------------- Jacob Skaria "Gunther" wrote: Typically the row heading on worksheets are numbers and the column heading are letters. For what ever reason, my worksheet is displaying both the row and column headings as numbers. It is very difficult to create formulas when their are two sets of numbers. How do I change the column heading to be letters? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want column heading non-scrolling and rows of each column scrol | New Users to Excel | |||
| How do I put a heading even with a column? | New Users to Excel | |||
| In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
| column heading | Excel Discussion (Misc queries) | |||
| Need to put a name in the column heading | Excel Discussion (Misc queries) | |||
Linear Mode
