Microsoft Excel

# How much rows does worksheet contains?

567 ###### 2009-08-25 15:09:43

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.

🦃
0
🤨
0
😮
0
😂
0

## 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.  Row numbers for the hidden rows will be missing on the side of the 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.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet. 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.  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). Rows are horizontal and numbered; columns are vertical and lettered.  A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.  It is a sheet that only contains a chart and has no columns or rows. It shows a chart completely on its own sheet instead of being embedded in a 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.  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.   