removing empty rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi

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

--
Andy.


Joe said:
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
Click to expand...
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,
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?


.
Click to expand...
 
Just delete them and SAVE the workbook.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Joe said:
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
Click to expand...
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?
 
Back
Top