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)
  • Yellowbox Level 5 Level 5 (6,465 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.

  • Yellowbox Level 5 Level 5 (6,465 points)

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

     

    Ian.

  • Wayne Contello Level 6 Level 6 (15,080 points)

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

  • 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

  • Wayne Contello Level 6 Level 6 (15,080 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.

  • SGIII Level 5 Level 5 (5,435 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