Maximum Size Of Worksheet

The cell reference address is displayed in the Cell Name Box and is determined by its representative column letter and row number. The first cell displayed in the upper left hand corner of any new workbook is cell A1 (the intersection of column A and row 1).

Excel allows over one million rows of data and over sixteen thousand columns of data. As Excel gets close to column Z, Excel doubles the letters and repeats the process so the column address’s show as W, X, Y, Z, AA, AB, AC…

If you were to go to the very last possible column its address would be XFD. If you went to the very last cell, its address would be XFD1048576.

No comments:

Post a Comment