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

Updated: 11/13/2018 by Computer Hope

The number of cells, columns, rows, and sheets supported by a spreadsheet depend on the software being used, and the data contained in the spreadsheet. Below is a list of the maximum number of rows, columns, cells, and individual sheets supported by various spreadsheet software.

Note: The below values are the theoretical limits. As data is inserted into a spreadsheet other factors such as how much memory the computer has also plays a role in the limits to how many rows, columns, and cells are supported.

Version Rows Columns Cells Sheets
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
Open Office Calc 3 1,048,576 16,384 17,179,869,184 256
Open Office 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 down the Ctrl key and press the down arrow key.

How to get to the last column of a worksheet

Press and hold down the Ctrl key 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, though users can create as many as their computer memory allows.

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.

Additional information