EMERGENCY (Deleting Columns)

Posted by Amit on November 05, 2001 7:55 AM

I have just began using excel,I have a spreadsheet that has about 10000 rows and 25 columns ,I have to delete those rows from Columns B and C which do not have data in them ,There seem to be quite a few such rows,Please help me out

Posted by Don on November 05, 2001 8:28 AM

Are both columns B and C blank in the rows which you need to delete? If so, you could sort by column B (or C). This will put all those rows that have no data in column B at the end of your spreadsheet. You can then delete all of those rows.

Does this help?

Posted by Amit on November 05, 2001 8:54 AM

ITS NOT WORKING,PLEASE

Don,this suggestion just deletes that particular variable in the row,I want the whole row (I have 25 variable in the row,such a pain :),to delete,I have to see that only the rows both the columns (B and C) which are empty are deleted,the method U told deletes those with just either B or C,Please help me out

Posted by Amit on November 05, 2001 9:29 AM

Thank you folks,I got it

Thank you all,I got the solution,Thanks