This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is there anyway to have Excel 2007 delete rows with certain parameters? Here is what I am trying to do:
I have an auto generated Excel .cvs file, which another program generates. But I need certain rows deleted and there are a lot of them scattered throughout the file. What I would like to be able to do is if one column is empty (i.e. no data in that column), I would like Excel to completely delete that whole row...all data in that row, in all the columns, all the way across, for that particular row. Right now, I am doing this manually and it takes forever.
Suggestions appreciated!
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
That is not correct.
If you follow the instructions all blanks in that column will be selected.
Delete Sheet Rows will delete and shift up all selected rows.
Gord
Ok, thanks! Trying that now. :)
Got it! Had to select the whole sheet first and now it worked! Thanks so much!
If you selected the whole sheet first, how did you select blanks in a single column?
Am happy the job got done.
Gord