Best Answer

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.

Study guides

☆☆

Q: What is the total maximum cells worksheet in 2007?

Write your answer...

Submit

Still have questions?

Related questions

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.

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.

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.

Since Excel 2007, continuing to Excel 2016, the maximum number of rows per worksheet is now 1,048,576 and the number of columns is 16,384. That makes 17,179,869,184 cells.

16,777,216 cells in Excel 2003 and earlier.17,179,869,184 cells in Excel 2007.

In Excel 2007 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.

Excel 2003 and earlier has 16,777,216 cells per worksheet (65,536 rows * 256 columns). Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).

That depends on the version you have. Up to and including Excel 2003, the standard amount of columns has been 256 and there has been 65,536 rows. That makes 16,777,216 cells. Since Excel 2007 the maximum number of rows per worksheet is now 1,048,576 and the number of columns is 16,384. That makes 17,179,869,184 cells.

The original version of Excel had a maximum limit of 16,777,216 (16.8 million) cells within a single worksheet and that continued to be the worksheet limit until it was later expanded in version 2007 to the current limit of 17,179,869,184 (17.2 billion) cells. Originally within each worksheet, Excel provided columns A to IV, which is 256 (2^8) columns; and 65,536 rows (2^16); therefore 256 x 65,536 = 16,777,216 (2^24). As mentioned, in version 2007 the worksheet maximum size limits were greatly expanded, providing columns A to XFD, which is 16,384 (2^14) columns; and 1,048,576 rows (2^20); therefore 16,384 x 1,048,576 = 17,179,869,184 (or 2^34).

The original version of Excel had a maximum limit of 16,777,216 (16.8 million) cells within a single worksheet and that continued to be the worksheet limit until it was later expanded in version 2007 to the current limit of 17,179,869,184 (17.2 billion) cells. Originally within each worksheet, Excel provided columns A to IV, which is 256 (2^8) columns; and 65,536 rows (2^16); therefore 256 x 65,536 = 16,777,216 (2^24). As mentioned, in version 2007 the worksheet maximum size limits were greatly expanded, providing columns A to XFD, which is 16,384 (2^14) columns; and 1,048,576 rows (2^20); therefore 16,384 x 1,048,576 = 17,179,869,184 (or 2^34).

Since Excel 2007, there are 1,048,576 rows by 16,384 columns in each worksheet. So the total number of cells would be 1,048,576 rows X 16,384 columns which is 17,179,869,184 cells. As there are 3 worksheets in a workbook by default, that is 51,539,607,552 cells in the workbook.

The original version of Excel up through version 2003 had a maximum limit of 16,777,216 (16.8 million) cells within a single worksheet and that continued to be the worksheet limit until it was later expanded in version 2007 to the current limit of 17,179,869,184 (17.2 billion) cells. Originally within each worksheet up through version 2003, Excel provided columns A to IV, which is 256 (2^8) columns; and 65,536 rows (2^16); therefore 256 x 65,536 = 16,777,216 (2^24). As mentioned, in version 2007 the worksheet maximum size limits were greatly expanded, providing columns A to XFD, which is 16,384 (2^14) columns; and 1,048,576 rows (2^20); therefore 16,384 x 1,048,576 = 17,179,869,184 (or 2^34).

People also asked