answersLogoWhite

0

Worksheets have to have a limit on the amount of rows you have. A computer only has a limited amount of memory, so it cannot be infinite. The vast majority of spreadsheets will not come anywhere close to using them, so you have more than enough. While you can insert extra rows, the amount of rows stay the same and the bottom row is pushed off the spreadsheet. The same applies to the final column. As no data is likely to be there or anywhere near the last row or column, there is no problem in pushing them off. Up to Excel 2003 there were 65536 rows and 256 columns. From versions 2007 on there are 1048576 rows and 16384 columns as modern systems do tend to have more data than the earlier versions were capable of dealing with.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What are the maximum rows of open office org calc?

The maximum number of rows available is 1048576 !


How many cells are there in the Excel worksheets 2016?

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.


How many rows in open office calc?

The maximum number of rows is 1048576.


How may rows in an Excel Worksheet?

The rows on exel are endless


How many cells do MS Excel 2010 have?

The maximum worksheet size is: 1,048,576 rows (across) by 16,384 columns (down). That is 17,179,852,800 cells.


A worksheet has rows that run vertically and columns that run horizontally?

No. Rows run horizontally and columns run vertically.


What is the maximum number of rows and columns you can use in Microsoft Excel 2007?

Colums : 16384 Rows : 1048576


When using spreadsheet software what are the rows and columns collectively are called?

Cells


What is a document that organizes data in rows and colums?

It is called a spreadsheet or a worksheet.


How are rows identified in a worksheets?

They appear Horizontally in a worksheet


How many rows are on a single page of Excel 2007?

In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.


What appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window?

columns