How many sheets, rows, and columns can a spreadsheet have?
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.
|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||*|
|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|
* Dependent on memory
How to get to the last row of a worksheet
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.