Excel - Deleting blank rows.

D

derm

I'm using Excel 2002 and have been sent a spreadsheet that has all th
information in the first 30 or so rows, but than had a calculation i
row 65,000. I've removed this calculation as it was not needed but
cannot now delete the 64,970 unwanted rows. Is this possible or am
stuck with them
 
A

Andy B

derm

Delete the unused rows, then save. When you reopen the sheet, it should be
OK.

Andy.

derm said:
I'm using Excel 2002 and have been sent a spreadsheet that has all the
information in the first 30 or so rows, but than had a calculation in
row 65,000. I've removed this calculation as it was not needed but I
cannot now delete the 64,970 unwanted rows. Is this possible or am I
stuck with them?
Click to expand...
creating financial statements
 

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

Merging from an Excel file with graphics 1
Deleting blank rows 5
How to filter rows data based on background color of individual cells 3
Can't save my Office documents (after computer rebuild and reauthorization) 0
Cannot remove empty rows 8
remove excess (unwanted) rows from the bottom of a speadsheet 3
Deleting rows which contain blank cells 11
Deleting Multiple Blank Rows 7

Top