deleting unnecessary rows from a spreadsheet

  • Thread starter Thread starter vikki
  • Start date Start date
V

vikki

Hi there,

Can a person do a global delete of unnecessary rows
within a spreadsheet? I'm copying information into excel
from notepad and notepad inserts an extra line between
entries when copied to excel and I don't want an extra
row between entries.

Thank you inadvance for your help!
 
Pick any column where you know that a blank cell means that row can be deleted, and then
select the entire range, do Edit / Go To / Special / Blanks, and then do Edit / Delete /
Entire Row.
 
You must log in or register to reply here.

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 extra rows in Excel 07 2
Excel And Notepad 3
I cannot delete the extra rows or columns in Excel 2007 2
automatically deleting blank rows? 3
How do I insert a row between every line in my spreadsheet? 3
"Phantom" Rows in Excel 2
Excel Help to copy information from one row at a time to another sheet 1
Links error when insert line/row to source workbook 1

Back
Top