You are here:

Geometry/Microsoft Excel Column Name Updates


Dear Prof Azeem

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

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

Examples :


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


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

Awaiting your reply,

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.

Thanks for asking,


All Answers

Answers by Expert:

Ask Experts


Azeem Hussain


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


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

CALPHAD: Computer Coupling of Phase Diagrams and Thermochemistry

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 All rights reserved.