The number of cells in one excel worksheet depends on how many cells you used for your spreadsheet, but listed below are the maximum supported by Excel.
Prior to Excel 2007 (2003 and earlier):
256 columns x 65,536 rows = 16,777,216 cells
Excel 2007:
16,384 columns x 1,048,576 rows = 17,179,869,184 cells
Yup! That's more than 17 Billion cells. (Assuming you have enough memory in your computer to use a spreadsheet that big.) That's so many, that if you read one cell per second, it would take you more than 520 years to read every cell in a spreadsheet that big!
And...if you have any memory left in your system, you might even try adding more worksheets. Theoretically, the total number of cells in a workbook is limited only by the amount of memory your system is able to access.
The squares are referred to as "cells" and there are a total of 17,179,869,184 cells per worksheet. Each excel workbook can have an unlimited number of worksheets.
There are 16,384 columns (A - XFD) and 1,048,576 rows, for a total of 17,179,869,184 cells per worksheet in Excel 2007.
In Excel there can be many hierarchies. Cells are in a worksheet, a worksheet is in a workbook. A grand total formula could be adding up the results formulas giving other totals. There can be hierarchy in graphics.
There are 16,384 columns (A - XFD) and 1,048,576 rows, for a total of 17,179,869,184 cells per worksheet in Excel 2007.
The last cell in Excel 2007 is XFD 1,048,576 There are 16,384 columns and 1,048,576 rows.
There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.
In Excel 2010 the number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes 17,179,869,184 cells.
In the Excel spreadsheet versions prior to 2002 or Office XP there are 65,536 rows and 256 columns , 65,536 x 256 = 16,777,216 cells or 'boxes'. Later versions of Excel have far more - millions of rows and thousands of columns. EDIT The latest version of Microsoft Excel that comes with Office 2007 has 17,179,869,184 cells in all. The columns are letter all the way to XFD and there are 1,048,576 rows.
Yes. The amount of cells depends on the version you have. The standard amount of columns has been 256. They are labelled by letters. After Z you get AA, AB, AC etc. until you get to AZ. Then it is BA, BB, BC and so on. The 256th column is IV. There has been 65,536 rows, all numbered. That makes a total 16,777,216 cells. That would have been the case in Excel 2003.In Excel 2007 the maximum number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes a total of 17,179,869,184 cells
The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.
Excel 2007 = XFD32 (16,385 total columns) Excel 2003 and earlier = IV32 (256 total columns)
Excel 2007 has 1,048,576 rows and 16,384 columns, so you it has a total of 17,179,869,184 cells.