6 Replies Latest reply: Nov 3, 2013 4:27 PM by SGIII
TrentErn Level 1 Level 1 (0 points)

Would like to password protect calculated cells (Numbers 9) from accidental erasure.

Tried the translucent shap locked over the calculated cells.

Problem with this is cell can still be tabbed into.

 

Protecting a cells contents a basic necessity.

Inability to do this is glaring oversight.

If I can't do this it looks like renewing  Microsoft Office license for my medical office and dumping iWorks.

This too bad as I otherwise like Numbers flexibility.

 

Trent


iMac (27-inch, Late 2012), OS X Mountain Lion (10.8.3)
  • 1. Re: how do I protect cell contents in iwork 9?
    Yellowbox Level 5 Level 5 (4,580 points)

    Hi Trent,

     

    In Numbers, you can not lock a range of cells within a table. However, you can move (or copy) those cells to another table and lock that table. The new table can be small (just the range of cells that you want to keep separate). You can hide that table on another Sheet if you wish.

     

    Menu > Table > Lock

     

    Make sure that the locked table has no formulas that link its values back to any other table. Formulas will still update the locked table.

     

    Have a look at Menu > Paste Values to paste values (not formulas) into the new table before locking it.

     

    The Numbers User Guide is a useful read. Download it from the Help Menu in Numbers.

     

    Regards,

    Ian.

  • 2. Re: how do I protect cell contents in iwork 9?
    Yellowbox Level 5 Level 5 (4,580 points)

    P.S. Any locked table can be unlocked by a Numbers-savvy user. This is not password protection.

     

    Ian.

  • 3. Re: how do I protect cell contents in iwork 9?
    Wayne Contello Level 6 Level 6 (13,620 points)

    You can suggest new features using the menu item in Numbers "Numbers > Provide Numbers Feedback"

  • 4. Re: how do I protect cell contents in iwork 9?
    DerbyD Level 1 Level 1 (0 points)

    REALLY!!!

     

    I've never used a spreadsheet which did not allow locking cells. My spreadsheet  has a number of individual (and scattered) cells that need to be open but it is too easy to accidentally put info in a cell that must not be changed and mess up the entire speadsheet.  I need to be able to lock the entire sheet and then unlock the specific cells which have info changed all the time.

     

    Major fail for Numbers

     

    Derby

  • 5. Re: how do I protect cell contents in iwork 9?
    Wayne Contello Level 6 Level 6 (13,620 points)

    Derby,

     

    Numbers has NEVER allowed locking particular cells.  It has always been on a by-table basis and user unlockable.  The generaly solution was to place user input in one table, then place calculations in a separate, locked, table.

  • 6. Re: how do I protect cell contents in iwork 9?
    SGIII Level 5 Level 5 (4,135 points)

    The generaly solution was to place user input in one table, then place calculations in a separate, locked, table.

     

    Great advice for using any spreadsheet, not just Numbers!  Keep input and calculations in separate places as much as possible. The table-centric design of Numbers makes segregation particularly convenient.

     

    SG