You are here:

- Home
- Science
- Math for Kids
- Geometry
- Microsoft Excel Column Name Updates

Advertisement

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

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

- Add to this Answer
- Ask a Question

Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |

Comment | Dear Prof Azeem Thank you. Thanks & Regards, Prashant S Akerkar |

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