Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » General » How to stop users moving a cell by accident

How to stop users moving a cell by accident

Previous | Next
Latest post Mon, Nov 16 2009 3:00 PM by keghead. 2 replies.

  • Sun, Nov 15 2009 10:52 PM

    • keghead
    • Top 500 Contributor
    • Joined on Mon, Nov 16 2009
    • Posts 2
    • Points 26

    How to stop users moving a cell by accident

    Reply |Contact

    Hi All

    I have a protected worksheet where all but a dozen cells are locked.  The unlocked cells are in A1:A12.  Occasionally, instead of entering data into A1:A12, the user will drag one of those cells onto another one unintentionally.  Often they have no idea that they have moved a cell.  Formulas in columns B:F reference the cells in column A so I end up with #REF! errors.  Is there a way to stop the user being able to move the cells?

    Cheers.
    • Post Points: 21

  • Mon, Nov 16 2009 12:56 AM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 233
    • Points 3,315

    Re: How to stop users moving a cell by accident

    Reply |Contact |Mark as Answer

    You can prevent drag and drop in all workbooks by unchecking "Allow cell drag and drop", which is found on the Tools (menu) | Options | Edit (tab)
    • Post Points: 21

  • Mon, Nov 16 2009 3:00 PM In reply to

    • keghead
    • Top 500 Contributor
    • Joined on Mon, Nov 16 2009
    • Posts 2
    • Points 26

    Re: How to stop users moving a cell by accident

    Reply |Contact |Mark as Answer

    Thanks, just what I wanted to know.
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.