How Do You Limit the Number of Rows in an Excel Spreadsheet?

1. Open Microsoft Excel from the 'Start' menu.
2. Press 'Alt' and 'F11' at the same time to open the visual basic editor.
3. Click 'View' on the top toolbar then select 'Project Explorer' from the drop down menu.
4. Click 'View' again then select 'Properties Window' from the drop down menu.
5. Select the name of the spreadsheet you are working with from the list in the explorer window on the left side of the screen.
6. Change the value in the 'ScrollArea' category to limit the number of rows allowed on the spreadsheet. For example, in order to limit the spreadsheet to 365 rows, you would enter the text '$1:$365' (without the quotation marks) into the ScrollArea box. To limit the spreadsheet to another number of rows just put that number in the place of 365 when entering '$1:$365' in the ScrollArea box.
7. Close the visual basic editor when you are done and the number of rows in the spreadsheet will be limited based on your specifications.