You are here:

Geometry/Microsoft Excel Column Name Updates

Advertisement


Question
Dear Prof Azeem

http://en.wikipedia.org/wiki/Microsoft_Excel
http://office.microsoft.com/en-in/excel/
http://www.microsoft.com/en-in/download/details.aspx?id=10
http://spreadsheets.about.com/od/tipsandfaqs/f/excel_use.htm
http://en.wikipedia.org/wiki/IP_address


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

Advantages
----------

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

Awaiting your reply,

Thanks & Regards,
Prashant S Akerkar

Answer
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.

Thanks for asking,
Azeem

Geometry

All Answers


Answers by Expert:


Ask Experts

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.

©2016 About.com. All rights reserved.