How many sheets, rows, and columns can a spreadsheet have?

Updated: 03/10/2024 by Computer Hope

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.

Note

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."