You are here:

- Home
- Science
- Math for Kids
- Geometry
- Cell Reference in Excel application.

Advertisement

QUESTION: Dear Prof Azeem

http://en.wikipedia.org/wiki/Microsoft_Excel

http://en.wikipedia.org/wiki/Matrix_(mathematics)

Cell Reference is intersection of column,row where data is to be inserted in the cell.

For example : A3 Cell data is 5. Now A3 cell is column 1 and row 3.

Instead of addressing a cell as columnrow i.e. A3 would we had use addressing a cell as rowcolumn, it would have become 3A. Now 3A=5.

In this case, the cell reference is 3A, now if this convention had

been applied instead of the columnrow convention for cell representation, would it had impacted other excel features ?.

Examples : 5C, 4B, 9R instead of C5,B4,R9 respectively.

The Matrix form representation is m rows * n columns.

Example : The notation of a 3 * 2 matrix : A[3,2] where number of

rows = 3 and number of columns = 2. There are total six elements in the matrix. A[2,3] matrix will be 2 rows and 3 columns with number of six elements in the matrix.

In excel, cell representation is A3 where A = Column name and 3 = row number and not 3A. i.e. ColumnRow and not rowcolumn convention.

In this case, the cell reference is 3A, now if this convention had been applied instead of the columnrow convention, a rowcolumn convention for cell representation, would it had impacted other excel features ?.

Example :

E3=7

R3C5=7

E3=R3C5

if i write 3E instead of using E3 and R3C5 cell references

saying 3E=7

Is 3E=E3 ?

3E=R3C5 ?

Awaiting your reply,

Thanks & Regards,

Prashant S Akerkar

ANSWER: Hi Prashant,

The current convention is preferred by most people. Data is typically arranged in rows, then columns. In many other contexts, the convention is "horizontal, then vertical," and Excel is in line with that. I do not see any positive impact of indexing cells column-row.

Thanks for asking,

Azeem

[an error occurred while processing this directive]---------- FOLLOW-UP ----------

QUESTION: Dear Prof Azeem

Thank you.

Example

-------

A1=3

R1C1=3

if i say 1A=3, can it impact other excel features viz formulas, creating charts,pivot table etc ?.

if it doesn't impact

other excel features, we can say

A1=R1C1=1A=3.

Awaiting your reply,

Thanks & Regards,

Prashant S Akerkar

Hi Prashant,

A1=R1C1=1A=3.

The letter always refers to the row and the number always refers to the column, but this is still a dangerous thing to do. Not wrong, but dangerous. Either way, there is still a convention that must be remembered (letter for column, number for row), so we might as well all just stick with row-column as usual.

Regards,

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.