Excel delete function question

Discussion in 'Mac Apps and Mac App Store' started by crypticlineage, Oct 14, 2010.

  1. macrumors regular

    Joined:
    Jun 24, 2010
    #1
    In Excel for office 08, the delete key will not clear contents of the selected cells, only of the first one. Everytime I need to right click and select clear contents.

    Also, if I wanted to delete the selected cells and move the bottom cells up, I would have to use the right click and choose delete option.

    Why doesn't the delete key work like it's supposed to?
     
  2. macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    It's working as designed. The delete key alone isn't supposed to clear contents from a range of cells or delete a cell.
     
  3. macrumors 6502a

    Joined:
    Feb 23, 2010
    Location:
    Virginia
    #3
    Because it's more of a Backspace than a Delete. Try Fn + Delete. I don't know it that actually works in Excel, but in most cases, Fn+Delete is the traditional "Delete"
     
  4. thread starter macrumors regular

    Joined:
    Jun 24, 2010
    #4
    so am I supposed to right click everytime? What if I have to go through 5000 cells? Clearly there must be a way to set this option? At the very least fn+delete or some such combination should do it, no?

    Thanks for moving my thread to the right place.
     
  5. macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #5
    Fn+Delete does clear contents of a cell or range of cells, but won't delete a cell.
     
  6. thread starter macrumors regular

    Joined:
    Jun 24, 2010
    #6
    Yes, the fn+delete deletes a range of cells.

    However, my other problem remains, being able to shift cells up, down or left right when I delete. I wonder if there is another key combination for that.

    Thanks for the tip.
     
  7. macrumors 6502a

    Joined:
    Feb 23, 2010
    Location:
    Virginia
    #7
    Searching Excel help for "keyboard"... The first hit is "Create a custom Keyboard shortcut". Tools/Customize Keyboard should help you set up a key combination for the Edit/Delete function.
     
  8. macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #8
    No, it clears the contents, but doesn't delete the cells.
    That's because fn+delete doesn't delete the cells. It only clears the contents, leaving the cells still there, but empty.
     
  9. thread starter macrumors regular

    Joined:
    Jun 24, 2010
    #9
    YES! YES! YES! Of course....

    I set up Cmd+D as my delete key, and viola, it deletes the range of selected cells and moves bottom cells up. Exactly what I wanted.

    Thanks.
     
  10. macrumors 601

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI

Share This Page