You are here:

# Geometry/Microsoft Excel Column Name Updates

Question
Dear Prof Azeem

http://en.wikipedia.org/wiki/Microsoft_Excel
http://office.microsoft.com/en-in/excel/

Do you feel Column Name changes from A, B, C to 1., 2., 3., 4. will have more advantages over the current
column name as A,B,C ... i.e. Similar to IP Address example 115.252.130.182

The Record/s names will remain the same as 1,2,3 ....

Examples :

1.

For example A1 refers to Column 1, Row 1 and has value as 3 so we refer the cell value as A1=3
Now instead of A1=3, we will refer as 1.1=3

2.

For example C4 refers to Column 3, Row 4  and has value as Hello so we refer the cell value as C4=Hello
Now instead of C4=Hello, we will refer as 3.4=Hello

----------

Since the column name is changed from character to whole number(integer), the values in the column can go take any limits.

For example :

999.56 refers to column  999 and  row 56
3456.43 refers to column  3456 and  row 43

Note : Column Name should be changed to 1. (i.e. 1 followed by a Dot) and not only 1 because if we keep only 1 then for example 123 creates a ambiguity of which is the column i.e. 1 or 12.

In this example 123 will lead to column 1 , row 23 or column 12, row 3

Correct :

12.3 refers to column 12, row 3
1.23 refers to column 1, row 23

Thanks & Regards,
Prashant S Akerkar

Hi Prashant,

It is a good idea for all the reasons you mentioned.  Using a comma instead of a period would also be more fitting, depending on the region.
The reason this is not currently in place is because many spreadsheets do not use a very high number of columns.  It is, for many, more comfortable to refer to a cell by a letter and a number than by two numbers.  Also, when entering it as a formula, it is also a bit easier because we don't have only numbers.

Azeem
Questioner's Rating
 Rating(1-10) Knowledgeability = 10 Clarity of Response = 10 Politeness = 10 Comment Dear Prof Azeem Thank you. Thanks & Regards, Prashant S Akerkar

Geometry

Volunteer

#### Azeem Hussain

##### Expertise

I welcome your questions on algebra, 2D and 3D geometry, parabolic functions and conic sections, and any other mathematical queries you may have.

##### Experience

4 years as a drop-in and by-appointment tutor at Champlain College. Private tutor for dozens of clients over the past 8 years.

Publications
CALPHAD: Computer Coupling of Phase Diagrams and Thermochemistry

Education/Credentials
Bachelor of Science, Major Mathematics and Major Economics, McGill University, 2014. Diploma of Collegiate Studies; Pure and Applied Science, Champlain College Saint-Lambert, 2010.