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

On Nov 26, 10:01*am,
.com wrote:
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.

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

" wrote:

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.

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

On Thu, 26 Nov 2009 08:11:01 -0800, JH wrote:

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

" wrote:

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.