| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
column headings problems
My view of the column headings has changed from A,BC's to numbers. Now the
rows and columns have numbers. Therefore my formulas no longer have alphabet vaulues in them. How do I change them back? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
column headings problems
ToolsOptionsGeneral tab
Uncheck: R1C1 reference style Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Wade" wrote: My view of the column headings has changed from A,BC's to numbers. Now the rows and columns have numbers. Therefore my formulas no longer have alphabet vaulues in them. How do I change them back? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
column headings problems
Wade
ToolsOptionsGeneral. Uncheck R1C1 reference style. Gord Dibben MS Excel MVP On Wed, 25 Jan 2006 12:16:03 -0800, "Wade" wrote: My view of the column headings has changed from A,BC's to numbers. Now the rows and columns have numbers. Therefore my formulas no longer have alphabet vaulues in them. How do I change them back? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
column headings problems
Thanks...that was very helpful
"Gord Dibben" wrote: Wade ToolsOptionsGeneral. Uncheck R1C1 reference style. Gord Dibben MS Excel MVP On Wed, 25 Jan 2006 12:16:03 -0800, "Wade" wrote: My view of the column headings has changed from A,BC's to numbers. Now the rows and columns have numbers. Therefore my formulas no longer have alphabet vaulues in them. How do I change them back? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
column headings problems
Thanks...that solved the problem
"Ron Coderre" wrote: ToolsOptionsGeneral tab Uncheck: R1C1 reference style Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Wade" wrote: My view of the column headings has changed from A,BC's to numbers. Now the rows and columns have numbers. Therefore my formulas no longer have alphabet vaulues in them. How do I change them back? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Column Headings | Setting up and Configuration of Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| move column headings from row to column | Excel Worksheet Functions | |||
Linear Mode
