In Microsoft Excel I have a worksheet which has somehow acquired approximately 65,000 rows of which only about 100 are in use. Is there any means of getting rid of the excess rows? Highlighting them and using Edit/Delete does not work as the rows immediately reappear. It is possible to use Format/Row/Hide but then it is not possible to increase the number of rows without going through Unhide/Hide routine. Normally a new worksheet does not open with so many rows so how has this happened and can it be prevented?
VoG Thanks for your solution but I had not assumed that it would be necessary to write a VBA programme to overcome the problem of the excess rows. However, as a developer you may know what determines the number of rows Excel chooses to include when opening a new worksheet and can this easily be changed?