millions
In Excel 97 there were 256 columns and 65536 rows.
There are 1,048,576 rows and 16,384 columns in Excel 2010
There are 256 Columns and 65,536 Rows in Excel 2000.
Up to 1,048,576 rows.
Rows are a horizontal arrangement of cells. All rows are numbered. The amount of rows depend on the version of Excel you have. Versions of Excel from 2007 have 1,048,576 rows. Before that, there was 65,536 rows.
There are 256 Columns and 65536 Rows in Excel 2003.
16,384 columns 1,048,576 rows
as many as number of rows in the version that is used less one row for col labl. is the max no of rows.
Excel 2007 has 1,048,576 rows, so it has more than 65,536 rows. Excel 2003 had 65,536 rows and it was not possible to increase that.
It depends on the height of the rows, the height of the paper, the margins you set, and many other factors.
If the version of Excel you are using only has 65536 rows, which was the case up to Excel 2003, then you can't add any more rows. From Excel 2007 onwards there are 1048576 rows, so that is what you would need to use.
There is no function to collapse rows in Excel, but you can hide rows you do not want to display. Highlight the rows you would like to hide and select Format | Hide and Unhide | Hide Rows.