Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers - How can I disable keyboard entry for selected cells?

Can anyone please tell me how I can disable specific cells from keyboard input in Numbers?

Thanks in advance....

iMac, OS X Yosemite (10.10.2)

Posted on Mar 31, 2015 10:11 AM

Reply
Question marked as Best reply

Posted on Apr 1, 2015 2:21 AM

You can not lock specific cells in Numbers only entire tables.. It is best to have a separate table for the cells that will be variable, and lock the summary table entire table with all the formulas in it.


To lock a table: select a cell anywhere within the table then go to Arrange<Lock, or press command-L

4 replies
Question marked as Best reply

Apr 1, 2015 2:21 AM in response to Jcoates55

You can not lock specific cells in Numbers only entire tables.. It is best to have a separate table for the cells that will be variable, and lock the summary table entire table with all the formulas in it.


To lock a table: select a cell anywhere within the table then go to Arrange<Lock, or press command-L

Numbers - How can I disable keyboard entry for selected cells?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.