delete duplicate cells in Excel 2008

Discussion in 'Mac Apps and Mac App Store' started by angelica22, Jul 19, 2010.

  1. macrumors newbie

    Joined:
    Jul 19, 2010
    #1
    Hello,

    does anyone know how to delete duplicate cells in Excel 2008 for mac?:confused::confused::confused::confused:

    Thanks
     
  2. macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    What exactly do you mean by "duplicate cells"?
     
  3. macrumors 601

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #3
    To delete any cell, highlight it, Select Edit > Delete and pick the action you want. Note: if the workbook is Protected, Delete will be greyed-out.
     
  4. macrumors regular

    Joined:
    Jun 20, 2010
    Location:
    London, UK
    #4
    Just create a pivot table and put the data you're looking at in the row field. This will only show unique records. Overwrite the old data with it. That's the simplest way to explain given the limited info you've given.
     
  5. macrumors newbie

    Rush Hamden

    Joined:
    May 10, 2011
    Location:
    Burbank, CA
    #5
    Hi, I've been using this forum for years to get info, thank you for everyone's hard work and input. :)

    This Excel 2008 issue is something that just came up for me as well, and by accident, I was able to sort a list by carrying out the following steps:

    Select record range (For example, all of Column B)
    Click on Menu Buttons: Data > Filter > Advanced Filter
    Check "Unique Records Only" box
    Hit OK
    All duplicate record rows were removed.

    I'm not sure if this will work every time for everyone, but I felt urged to contribute this possible solution.

    God bless.

    Rush.
     

Share This Page