Deleting empty rows in Excel

Watch Reply
More
Mark unread Print Skip to new
Leftwood Saint Bonifacius, MN(Zone 4a) Feb 27, 2009

I am using Excel 97.

I am using a template I produced, and have inserted many rows where I want them. Now I have excess empty rows at the bottom of the sheet that I don't need. Deleting these already empty lines at the end of the sheet with the -edit>>delete...>>entire row- doesn't work. The only way I have found to solve the problem is to highlight the rows I have filled, and copy them to a new sheet, and deleting the original. While this is doable, it presents some other tedious complications.

I could transfer the sheet to an Excel 2000 version, if that would help, but isn't there an easier way?

Post #6199575
Quote
This thread has 16 replies. This forum is accessible only to subscribing members of Dave's Garden. There are many free features here, and about half of our forums are completely open to all members. And learn more about Dave's Garden, and explore the benefits of becoming a subscribing member.

Want to join? Register here. Already signed up? Click here to login!

Back to Forum Homepage

More Computer Talk Threads

Go to all Computer Talk threads
BACK TO TOP