Ranges and Arrays in Excel

Ranges and arrays are how Excel refers to groups of columns and rows. The difference lies in how they are used. A range is a group of rows and columns in an Excel spreadsheet, while an array is a group of rows and columns used in an Excel function or code. In Excel, an array most closely approximates a matrix. 

Absolute Rows and Columns ( A 2) in this case, the reference will always be to this cell. 

Absolute Column but Relative Row ( A2) in this case, the column will stay the same, but the row can change. 

---