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

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.

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

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.

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

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.

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

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.