What is the meaning of a cell pointer in Microsoft Excel?
Microsoft Excel uses a column/row nomenclature to give each cell in the spreadsheet a unique address. This unique address is called a cell pointer, or cell reference, and may be referenced in a number of ways by Excel.Format of a Cell PointerCell references are assigned, by default, with a name like Sheet1!A1. The first part of the name (Sheet1) refers to which worksheet the cell is on. The second part, after the exclamation point, is the column (A) and row (1) that the cell is in.Range of Cell Pointers in an Excel 2007 WorksheetCell A1 is the top left cell on a given worksheet. In Excel 2007, Cell columns range from A to XFD, which is 16,384 columns. Rows run from 1 to 1,048,576.Relative References To Cell Pointers in FormulasWhen referring to the contents of a cell, use its column and row identifier. Excel cell pointer references are relative by default. If you make the formula “=SQRT(A1^2+B1^2)” in cell C1 and copy it to cell E27, the formula in the new cell will read as “=SQRT(C27^
