Excel excess rows

  pienter 12:38 25 Dec 2004

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?

Seasonal geetings to one and all

  VoG II 12:49 25 Dec 2004
  pienter 14:00 26 Dec 2004

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?

  VoG II 16:42 26 Dec 2004

All worksheets are 256 columns x 65,536 rows, and there isn't anything that you can do about that.

Normally you won't get down as far as 65,536 rows. However, sometimes Excel seems to get confused about where the last cell is so your "used range" appears to be enormous.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?