Excel excess rows

  pienter 12:38 25 Dec 04

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 04
  pienter 14:00 26 Dec 04

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 04

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced