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
 

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
Working with a speadsheet of 15,000 rows 1
How do I get rid of unused rows at the bottom of the book? 1
How do I get rid of a blank row at bottom of Excel spreadsheet? 1
How do I remove excess pages in Excel? 2
How do I conceal the unused range from the scroll bar? 1
Excel copy only visible rows from autofilter 2
Combining data from multiple rows 2

Back
Top