Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Edgecomb, Maine
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Get rid of blanks (Excel 2007)

    Hi All,
    I just got Excel 2007, navigating around is quite a bit different than 2003. I have a spreadsheet with data in one column. There are several blanks between each data set. I was able to do an autofilter to display all the text without the blanks, but can't figure out how to 'delete' the blanks rather than 'hide' them as the autofilter did.

    Can anyone tell me how to do that?

    Thanks,

    --Jim

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get rid of blanks (Excel 2007)

    Select a column, do Goto (F5), special, blanks. Then rightclick and choose delete and select entire row.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Edgecomb, Maine
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get rid of blanks (Excel 2007)

    Wow, it was that easy. I had no idea to try that.

    Thanks!

    --Jim

Posting Permissions

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