Spread Formula Reference
A1 (Letter-Number) Notation

Each cell can be referenced by a combination of its column letter (A through Z, then AA to ZZ, AAA to ZZZ, etc.) and row number (1 and beyond) for a total of 2,147,483,648 rows and columns. For example, D50 refers to the cell at the intersection of column D and row 50. To refer to a range of cells, enter the reference for the cell in the upper-left corner of the range, a colon (:), and then the reference to the cell in the lower-right corner of the range.

See also these topics:

For more information on setting the reference style for a cell, refer to the ReferenceStyle enumeration in the product’s Assembly Reference (or help) and the ReferenceStyle property for the specific sheet (SheetView object).

Return to Cell References in a Formula

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options