removing empty rows

[Guest]

Please can you tell me how to delete empty rows at the bottom of a worksheet
If for instance I have 1000 records on a worksheet and then cut and paste most of the records to another worksheet, leaving say 50 records, the original sheet will now have 950 empty rows. Is it possible to remove the empty rows so that moving the scroll bar to the bottom results in the last populated row being displayed, i.e row 50, rather than the empty space left by the records that have been moved, i.e. row 1000

 

[Andy B]

Hi

Have a look at how to reset your used range:
http://www.contextures.com/xlfaqApp.html#Unused

--
Andy.

Please can you tell me how to delete empty rows at the bottom of a worksheet?
If for instance I have 1000 records on a worksheet and then cut and paste

most of the records to another worksheet, leaving say 50 records, the
original sheet will now have 950 empty rows. Is it possible to remove the
empty rows so that moving the scroll bar to the bottom results in the last
populated row being displayed, i.e row 50, rather than the empty space left
by the records that have been moved, i.e. row 1000?

 

[Guest]

Andy,
Thank you very much for you help.
Joe.

-----Original Message-----
Hi

Have a look at how to reset your used range:
http://www.contextures.com/xlfaqApp.html#Unused

--
Andy.


bottom of a
worksheet? then cut and paste
most of the records to another worksheet, leaving say 50 records, the
original sheet will now have 950 empty rows. Is it possible to remove the
empty rows so that moving the scroll bar to the bottom results in the last
populated row being displayed, i.e row 50, rather than the empty space left
by the records that have been moved, i.e. row 1000?


.

 

[Don Guillett]

Just delete them and SAVE the workbook.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Please can you tell me how to delete empty rows at the bottom of a worksheet?
If for instance I have 1000 records on a worksheet and then cut and paste

most of the records to another worksheet, leaving say 50 records, the
original sheet will now have 950 empty rows. Is it possible to remove the
empty rows so that moving the scroll bar to the bottom results in the last
populated row being displayed, i.e row 50, rather than the empty space left
by the records that have been moved, i.e. row 1000?