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

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.
 
P

Pete_UK

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
 
J

JH

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting excess rows from a spreadsheet 1
How do I get rid of unused rows at the bottom of the book? 1
Working with a speadsheet of 15,000 rows 1
How do I conceal the unused range from the scroll bar? 1
force new record to be at bottom of continuous subform? 4
Auto copy and insert a defined number of rows as defined in a cell 1
Excel thinks I have another 200+ rows at the bottom of my rows. H. 7
Anchoring a section break to the bottom of a page 5

Top