Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Cells don't delete (2003)

    How come I can't delete cells in a SS that someone sent me? It only allows for rows. But when I copy the info to a new SS, I can.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cells don't delete (2003)

    Perhaps teh worksheet is protected. Under tools - protection does it say "protect sheet" or "unprotect sheet"?

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cells don't delete (2003)

    Is the worksheet protected? (Look at Tools | Protection - if the first item in the submenu is Unprotect sheet, it's currently protected).

    Otherwise - what happens if you try to delete cells? Do you get an error message? If so, what does it say?

  4. #4
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Cells don't delete (2003)

    I have seen that "Protect", "unlocked" and "locked" cells was checked off. However, the creator of the worksheet didn't put a password on it. Maybe it was given to someone who protected it. Is there some way I can strip that? (I also unlocked all the cells).

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cells don't delete (2003)

    You can remove the protection by tools - protection - unprotect sheet. If the worksheet is unprotected, the status of the locked/unlocked nature of the cell does not matter. It is only relevant for protected sheets

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cells don't delete (2003)

    What exactly did the first item in the Tools | Protection submenu say? "Protect sheet..." or "Unprotect sheet..."? Or perhaps more important, what does it say now? (Don't select the option, only look at it).
    If it says "Protect sheet", the sheet is currently not protected.
    If it says "Unprotect sheet", the sheet is currently protected.

  7. #7
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Cells don't delete (2003)

    It said "protect sheet". I knew that meant it was unprotected, but it still did not allow me to sort or delete cells.

  8. #8
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Cells don't delete (2003)

    I may have been mistaken about the sort capability which is working, but the original sheet doesn't support cell deletion. I have been able to make a new SS which does it. But the original doesn't, could it be different versions? (I'm on 2003, could be that one is 2007). In any event I'm okay.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cells don't delete (2003)

    I'm afraid I'd have to see the workbook.

Posting Permissions

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