+ Reply to Thread
Results 1 to 3 of 3

remove blank rows in excel

  1. 06-12-2012, 11:56 PM #1
    angie.chang
    angie.chang is offline
    Registered User
    Join Date
    11-12-2011
    Location
    Glendale, CA
    MS-Off Ver
    Excel 2007
    Posts
    18

    remove blank rows in excel

    Is there a faster way to delete all blank rows in excel?

    Thanks,

    Angie
    Reply With QuoteRegister To Reply
  2. 06-13-2012, 12:06 AM #2
    puru.sve
    puru.sve is offline
    Registered User
    Join Date
    06-28-2011
    Location
    New Delhi India
    MS-Off Ver
    Excel 2003 ,2007
    Posts
    23

    Re: remove blank rows in excel

    either Use can use filter and select blank row ......or select your first column then press F5 --> Special --> Select Blank ---> then do ctrl + '-' and delete row.
    Purushottam
    Excel, MS ACCESS 2007
    Reply With QuoteRegister To Reply
  3. 06-13-2012, 10:15 AM #3
    KSSLR
    KSSLR is offline
    Registered User
    Join Date
    06-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: remove blank rows in excel

    Angie,

    If there is a blank cell in Column A, this code will delete the whole row:

    Please Login or Register  to view this content.
    Any further tweaking will have to be done by a more seasoned user than I...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1