Answer:
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.