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?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
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

Deleting blank rows 4
How To Have A Cell Be Blank If... 2
Deleting rows with formulas is very slow 2
Deleting Blank Rows. 3
Deleting rows in Excel 2007 using filters 1
Deleting/removing unused rows in a worksheet 3
automatically deleting blank rows? 3
Deleting Multiple Blank Rows 6

Top