Top Nav

Remove Empty Cells in Excel 2007 or 2010 Spreadsheets

 

Ready to remove those pesky empty cells in Excel? Here’s how to do it.

Open your spreadsheet and press [Ctrl] [A] to highlight the entire document. Or highlight just the section of the spreadsheet where you want to remove empty cells.

select the cells from microsoft excel that you want to be removed

Now, press F5 on your keyboard. The Go To menu will appear. Click the Special button.

special go to selections in microsoft excel

The Go To Special window comes up. Select Blanks and click OK.

select blank cells in microsoft excel

Now, Excel will select all blank cells in your document.  To get rid of these hold [Ctrl] [-] on your keyboard. The delete window opens. Select Entire Row or Entire Column to shift cells around and remove the empty ones.

Delete entire row Excel

 

More Reading:

, , , ,

23 Responses to Remove Empty Cells in Excel 2007 or 2010 Spreadsheets

  1. HankD January 31, 2012 at 4:37 am #

    Hi! This is exactly what I was looking for – and when I try to run this my Excel 2010 finds the empty rows but when I try to delete them the program does not respond and I can’t do the deletions. I seem to have 65000 rows and been trying this several time s now, with same result. Hmmm…any idea for me?
    Best /Hank

    • Dr D June 12, 2013 at 10:24 am #

      try doing it in smaller sections, that way your program won’t freeze up. If that doesn’t work you can always do a seek and find for blank rows only. after you separate them you can just delete them all.

  2. Miguel September 11, 2012 at 2:26 am #

    marvellous mate: 3Es4this Easy, Elegant and Effiecient !

  3. Jaison October 31, 2012 at 2:10 am #

    The above deletes all the cells, but you can try filter & sort – blank cells and delete all the blank cells.

  4. Jaison October 31, 2012 at 2:14 am #

    The above deletes all the cells, but you can try Sort & Filter – un-check Select All box, then click the blank cell check boxe. this will sort all your blank rows and then delete the rows.

  5. Fahad Gilani June 25, 2014 at 11:09 pm #

    Thank you Austin, this is what I was looking, it helps me a lot.

  6. Sal January 22, 2015 at 9:51 am #

    Worked perfectly 1st time around, exactly what I was looking for- thanks!!

  7. Rach March 24, 2015 at 6:16 am #

    Thank you so much you just saved me about 3 hours of deleting individual blank cells.

  8. GVLNSRK April 7, 2015 at 4:16 am #

    THANK YOU SAVED ME TO DEPENT ON OTHERS

  9. Geekgurl April 21, 2015 at 5:09 am #

    Thanks!!

  10. Thiery May 24, 2015 at 1:52 pm #

    Thumbs up bro

  11. mohammad hosein June 28, 2015 at 6:25 am #

    salaam
    very usefull
    so great
    thanks a lot

  12. Julius July 5, 2015 at 8:45 pm #

    Nothing works for me. After I select Blanks and click ok, I get a box that pop up and says “No cells were found”. What other options do I have

  13. Sue H July 17, 2015 at 3:26 am #

    Fantastic. Worked a treat.
    (You have to remember to highlight all of the data that you want to clear the blank cells from).
    Thank you so much.

  14. surya August 27, 2015 at 1:06 am #

    hi. hello Austin..
    i need help from you.
    i tried to delete all blanks cells without leaving one blank cell in a row , but it delete all cells on sheet , i want leave some blank cells in different rows and columns. please give me way..thankyou

  15. Dear Austin November 2, 2015 at 10:08 pm #

    Superb solution to delete blank rows. Thanks a lot, but what if we want to add multiple rows in the sheet when the value change by considering a column.

  16. Phil November 19, 2015 at 7:54 am #

    Thanks, Worked great

  17. atul bhardwaj January 1, 2016 at 2:27 am #

    thanks very useful.

  18. Karen January 21, 2016 at 8:33 am #

    Really helpful and has saved me loads of time.

  19. Lali Lingfa February 9, 2016 at 8:12 am #

    Thank you very much for excellent information.

  20. dolapoking March 16, 2016 at 7:45 am #

    Thanks! it really helped.

  21. Watergrrl March 23, 2016 at 11:07 am #

    I love you.

  22. Morad Hassan April 8, 2016 at 11:18 am #

    You’re my F*&%ing HERO! Thanks!!!!!

Leave a Reply