Showhow one of my worksheets had about 63,609 rows added in and grew from about 2Kb to 3702KB. Since I only have data in about 500 rows I'd like to reset it to have only the 500 rows I need. The quickest and easiest way to do this that I can think of is to simply create a new worksheet and copy my data to it and then delete the old worksheet. But since I'm neurotic I'd like to know how to customize the worksheet size itself. Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Decreasing number of rows in a spreadsheet
- Thread starter rllrdurst
- Start date
