Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anyway to set numerical column name as Exel convention?
It's awkward for me to use "A, B, ...CW..." as column names, when large
matrices of data are processed. I couldn't find a way to change the column name convention in Excel to regular numbers "1,2,3....", just as the convention of the row names. Also, I could not find a good reference book, or online reference document, describing how to rely on numerical references to worksheet locations during large matrices manipulations. All references I have found a based on "mouse, click, drag...", which are very impractical for large matrices operation. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anyway to set numerical column name as Exel convention?
Use Tools | Options |General and put check in top left box "R1C1 reference
style" best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Frank Cao" <Frank wrote in message ... It's awkward for me to use "A, B, ...CW..." as column names, when large matrices of data are processed. I couldn't find a way to change the column name convention in Excel to regular numbers "1,2,3....", just as the convention of the row names. Also, I could not find a good reference book, or online reference document, describing how to rely on numerical references to worksheet locations during large matrices manipulations. All references I have found a based on "mouse, click, drag...", which are very impractical for large matrices operation. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anyway to set numerical column name as Exel convention?
Tools-Options-'General' Tab-Check "R1C1 reference style" to get the
column's listed as numbers instead of letters. -- Regards, Dave "Frank Cao" wrote: It's awkward for me to use "A, B, ...CW..." as column names, when large matrices of data are processed. I couldn't find a way to change the column name convention in Excel to regular numbers "1,2,3....", just as the convention of the row names. Also, I could not find a good reference book, or online reference document, describing how to rely on numerical references to worksheet locations during large matrices manipulations. All references I have found a based on "mouse, click, drag...", which are very impractical for large matrices operation. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anyway to set numerical column name as Exel convention?
Have you tried this:
From the Excel main menu.... ToolsOptionsGeneral Check: R1C1 reference style Does that help? *********** Regards, Ron "Frank Cao" wrote: It's awkward for me to use "A, B, ...CW..." as column names, when large matrices of data are processed. I couldn't find a way to change the column name convention in Excel to regular numbers "1,2,3....", just as the convention of the row names. Also, I could not find a good reference book, or online reference document, describing how to rely on numerical references to worksheet locations during large matrices manipulations. All references I have found a based on "mouse, click, drag...", which are very impractical for large matrices operation. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anyway to set numerical column name as Exel convention?
Thank you: David and Ron.
"Frank Cao" wrote: It's awkward for me to use "A, B, ...CW..." as column names, when large matrices of data are processed. I couldn't find a way to change the column name convention in Excel to regular numbers "1,2,3....", just as the convention of the row names. Also, I could not find a good reference book, or online reference document, describing how to rely on numerical references to worksheet locations during large matrices manipulations. All references I have found a based on "mouse, click, drag...", which are very impractical for large matrices operation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
alpha column changed to numerical column | New Users to Excel | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |