+ Reply to Thread
Results 1 to 2 of 2

remove blanks rows from data

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    remove blanks rows from data

    i have a data in excel sheet but there is a blank rows between data and i want to remove it .. but data is too huge .. i also search it how to remove blank rows.. and i get this point go to special then option blank and click OK.. and from this blank spaces will be selected and so you able to delete it but when i done this blank rows not remove from data ..how i solve this

  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2010

    Re: remove blanks rows from data


    Assume data contains in range A1:D10
    row#3,4 & 7 are blank

    You need to follow the below steps:

    1) Select range A1:D10
    2) Press F5 key to open GO TO DIALOG BOX
    3) From Special click on Blanks (this will highlight all the blank cells as you mentioned it)
    4) Use CTRL + - (Dash) shortcut keys
    5) Select Entire row


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Select huge data and remove blanks - How
    By neonlights in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 02:45 PM
  2. [SOLVED] VBA Code to align rows and remove blanks.
    By SamCV in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2013, 11:11 AM
  3. Copy Rows - Paste and remove blanks
    By tigerdel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2012, 01:28 PM
  4. Reformat data to remove blanks
    By yunesm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2011, 12:39 PM
  5. Remove Blanks from Data Validation
    By barteh in forum Excel General
    Replies: 17
    Last Post: 02-11-2011, 11:07 AM


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1