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.
 
Back
Top