Anyway to set numerical column name as Exel convention?

[Frank Cao]

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.

[Bernard Liengme]

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 [email protected]> wrote in message
news:[email protected]...
> 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.

[David Billigmeier]

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.

[Ron Coderre]

Have you tried this:

From the Excel main menu....
Tools>Options>General
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.

[Frank Cao]

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.