Even after selecting the rows or column to be deleted, one can press the context key or shift F10 and select delet, than rows or columns respectively.
Do let me know if this sounds convenient. Regards Sushmeetha -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mujtaba Merchant Sent: 24 June 2012 10:42 To: [email protected]; Voice Vision Subject: [VV] Knowledge Sharing: Delete Blank Rows From A Long List (Excel 2010, 2007, 2003) Hello Folks, Today we are going to learn to accomplish the tedeous task of deleting blank rows in our excel sheet without messing up our data. Suppose you receive a list of data that contains blank rows that you want to remove without affecting the order of the list. This technique will allow you to delete all rows that have blank cells in a particular column. Here's the fastest way to do it. First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data . Now, select the cells in one column from the top of your list to the bottom, control+spacebar, selects entire column. Make sure that all the blank cells in this selected range are the rows you want to delete. Press the F5 key on your keyboard (or select Edit, Goto). Tab and Click the Special... button. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected. Now choose Edit, Delete, select the Entire Row option and click OK. This deletes all blank rows in your excel data sheet! Coffee break time. Mujtaba Merchant Bangalore, India _______________________________________________ Visit our website at http://www.voicevision.in Join us on Facebook: http://www.facebook.com/voicevisionfans Or follow us on Twitter at http://www.twitter.com/voicevision_in List mailing list [email protected] For list guidelines & other subscription changes visit http://voicevision.in/mailman/listinfo/list_voicevision.in -------------------------------------- Ascent Networks Pvt Ltd, Mumbai, India Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
