remove excess (unwanted) rows from the bottom of a speadsheet

  • Thread starter Thread starter alun.reece
  • Start date Start date
A

alun.reece

I have some spreadsheets submitted to me that are upto 65000 rows, with only
the first 4000 rows used. How can I remove these unwanted rows. Deleting only
replaces teh rows with new blank rows. At the moment I am cutting / pasting
in to a new worksheet and then re-establishing all the links. THere must be
an easier way.
 
You can't remove them, as the sheet is a fixed size. However, you can
hide them. Select the rows below the data then click on Format | Rows
| Hide then click OK.

Hope this helps.

Pete
 
Hi,
After you deleted the unwanted rows, you need to save the workbook,
then the end of the file will not include the blank rows.

JH
 
Incorrect.

I think you are speaking of resetting the used range on a worksheet.

The number of rows on a sheet is fixed.


Gord Dibben MS Excel MVP
 
Back
Top