How many sheets, rows, and columns can a spreadsheet have?
The number of cells, columns, rows, and sheets supported by a spreadsheet depends on the software used and the data contained in the spreadsheet. Below is the maximum number of rows, columns, cells, and individual sheets supported by various spreadsheet software.
The below values are the theoretical limits. Other factors, including how much memory the computer has, determine how many rows, columns, and cells are supported.
Version | Rows | Columns | Cells | Sheets |
---|---|---|---|---|
Excel 2019 | 1,048,576 | 16,384 XFD | 17,179,869,184 | * |
Excel 2016 | 1,048,576 | 16,384 XFD | 17,179,869,184 | * |
Excel 2013 | 1,048,576 | 16,384 XFD | 17,179,869,184 | * |
Excel 2007 | 1,048,576 | 16,384 XFD | 17,179,869,184 | * |
Excel 2003 and earlier | 65,536 | 256 | 16,777,216 | * |
Google Sheets | 256 | 400,000 | 200 | |
OpenOffice Calc 3 | 1,048,576 | 16,384 | 17,179,869,184 | 256 |
OpenOffice Calc 2 | 65,536 | 256 | 16,777,216 | 256 |
Gnumeric | 65,536 | 256 | 16,777,216 | * |
KSpread | 32,767 | 32,767 | 1,073,676,289 | * |
Lotus 1-2-3 | 65,536 | 256 | 16,777,216 | 256 |
LibreOffice Calc | 1,048,576 | 1,024 | 1,073,741,824 | 10,000 |
* Dependent on memory
How to get to the last row of a worksheet
Press and hold Ctrl and press the down arrow key.
How to get to the last column of a worksheet
Press and hold Ctrl and press the right arrow key.
How many sheets are there in an Excel workbook?
By default, there are three sheets in a new workbook in all versions of Excel, though users can create as many as their computer memory allows. These three worksheets are named Sheet1, Sheet2, and Sheet3.
How many characters can fit into a single cell?
The total number of characters a cell can contain is 32,767.
How are rows and columns labeled?
In all spreadsheet programs, including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1,048,576). All columns are labeled with letters "A" through "Z," then "AA" through "ZZ," etc. For example, after the letter "Z," the next column is "AA," "AB," "AC," ..., "AZ," and then incrementing to "BA," "BB," "BC," etc.
To identify a cell, give both the column and the row. For example, the first cell is always located in column "A," on row "1," so the cell is labeled "A1."