Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
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
Re: EMERGENCY (Deleting Columns)
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?
ITS NOT WORKING,PLEASE
Posted by Amit on November 05, 2001 8:54 AM
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
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
Thank you folks,I got it
Posted by Amit on November 05, 2001 9:29 AM
Thank you all,I got the solution,Thanks
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.