Let's assume that a worksheet in Microsoft Excel is divided into over 1 million rows and over 16,000 columns. The rows are labeled 1, 2, 3, and so on, up to 1,048,576, and the columns are labeled A, B, C, and so on, up to XFD. The rows and columns intersect to form over 16 billion cells in one worksheet.
However, since a cell is identified by the columns and rows that intersect to form it, each cell has a unique identification, which is conventionally written as the intersecting column and row names. Thus, the UV column and row 59 form the UV59 cell. There is no other UV59 cell on that worksheet, of that workbook, on that computer. This feature forms the basis for the referencing framework in Excel. This chapter will talk about the various types of referencing frameworks and how to implement each one of them in order to simplify...