Lock spreadsheet

I used to be able to lock my spreadsheet in Numbers to prevent it from being edited, but the latest update I do not see the lock feature.

Has it been removed?

iPhone 12 Pro, iOS 16

Posted on Oct 31, 2022 10:10 AM

Reply
Question marked as ⚠️ Top-ranking reply

Posted on Nov 4, 2022 8:42 AM

This confused me, too. It seems to be hidden in the three-dot menu and is called "Reading View". If you open that menu (upper right) and client Reading View, the Edit you/we used to see shows in the top right.


But, be careful: even with the Edit showing, a double-click on a cell can allow changes. It's a weird situation IMO, but this is the best I can find to replicate what you/we used to use. Hope this helps.

5 replies
Sort By: 
Question marked as ⚠️ Top-ranking reply

Nov 4, 2022 8:42 AM in response to tinman63

This confused me, too. It seems to be hidden in the three-dot menu and is called "Reading View". If you open that menu (upper right) and client Reading View, the Edit you/we used to see shows in the top right.


But, be careful: even with the Edit showing, a double-click on a cell can allow changes. It's a weird situation IMO, but this is the best I can find to replicate what you/we used to use. Hope this helps.

Reply

Oct 31, 2022 3:08 PM in response to tinman63

If you're trying to protect a whole document (a spreadsheet in Numbers lingo), then you have File > Set Password... .


If you're trying to lock a table to prevent inadvertent changes, then you can click the table and go to Arrange > Lock.


Of course any user can click that table and go to Arrange > Unlock. So it doesn't provide complete protection.


SG

Reply

Nov 1, 2022 4:53 AM in response to tinman63

This is the Numbers for Mac forum. I think what you are referring to is a feature in Numbers for iOS/iPadOS that isn't a "lock" per se, but more of a display mode. The 'Edit' button to enter edit mode is still there in Numbers on my iPhone and iPad.


SG



Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Lock spreadsheet

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