There are 1,048,576 rows and 16,384 columns in a Microsoft Excel 2010 spreadsheet. So if you multiply 1,048,576 by 16,384 you get 17,179,869,184 cells.
Wiki User
∙ 2014-06-21 22:04:35Excel 2010 has 16,384 columns, as does Excel 2007. Versions prior to that had 256 columns.
16,777,216 cells in Excel 2003 and earlier. 17,179,869,184 cells in Excel 2007
16,777,216 cells in Excel 2003 and earlier.17,179,869,184 cells in Excel 2007.
36
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.
65,536 rows by 256 columns gives 16,777,216 cells.
17,179,869,184, which are made up of 1,048,576 rows by 16,384 columns.
Microsoft Excel 2000 has 256 columns.
Microsoft Access is a database application and it does not have cells in the way a spreadsheet does. A datasheet in Access is not the same as a worksheet in Excel and it does not have a fixed amount of columns, rows and cells. So there is no answer to the question.
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.
Excel cells hold numbers and text. You can format the characters in many ways. You also can place objects and images on a worksheet, but they really do not go in the 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.