answersLogoWhite

Top Answer
User Avatar
Wiki User
Answered 2009-10-31 18:58:16

The amount of rows in a worksheet is fixed, so you cannot increase the amount of rows. What you can do is insert rows into part of a spreadsheet. It will have the effect of pushing rows down, but it will not increase the amount of rows in the worksheet. One of the reasons there are so many rows is that you will never use all of them, so it can push rows down to accommodate inserted rows and get rid of blank rows, but not increase the amount of rows that are in the worksheet. Excel 2007 has more rows than many of the earlier versions. It is has 1,048,576 rows whereas many of the earlier versions had 65,536 rows. Even that is more than enough to accommodate the spreadsheets that people normally create.

123
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
๐Ÿ˜‚
0
User Avatar

Your Answer

Related Questions


Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.


There are 1,048,576 rows in each Excel 2007 worksheet.


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.


there are 65,536 rows and over 200 cells (IV) (:


They appear Horizontally in a worksheet


Row numbers for the hidden rows will be missing on the side of the worksheet.


The rows on exel are endless


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.


For .xls (used by Excel 2003 and earlier), rows 65536, columns 256 For .xlsx (Excel 2007 and 2010),rows 1048576, columns 16384



Rows are horizontal and numbered; columns are vertical and lettered.


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.


A worksheet consists of columns and rows, making up cells.


A Microsoft Excel 97 through Excel 2003 worksheet contains 65,536 rows. A Microsoft Excel 2007 workbook saved in one of the new formats (.xlsx, .xlsm) has worksheets with 1,048,576 rows.


No. Rows run horizontally and columns run vertically.


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.


by numbers on the left side of the screen


Rows and columns, which in turn gives you cells.




You can insert rows above or below the selected row. You select what you would like to do on the insert worksheet rows menu.



It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.It means to add a new column or row into a worksheet. It will push other rows down or other columns to the right. You will often have the need to insert extra rows or columns to accommodate new data you want to put in between existing rows and columns.




Copyright ยฉ 2021 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.