hello sushmeetha, many thanks for the knowledge sharing . suppose, if we have non adjecent cell data's in different columns including blank rows, how to pick only the data? it's too simple, as said by mujtaba sir, we have to accomplish the selection by f5 or ctrl plus g to get the goto dialogbox, tab to hit special and select blank using arrow keys. note that, selection is announced by jaws as we complete the task. next, to delete can use any of the method said as above by you and by sir, hit the shift cells up , from home/ cells/ delete/ delete cells/ shift cells up. check out. it's done. kindly,please keep posting such valuable knowledge sharing.
On 6/25/12, Sushmeetha <[email protected]> wrote: > 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 > > -- Cheers, Radha 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
