how do i lock cells in numbers

Forgive me for being dense, but I think I am missing the distinction between "an entire table" and the entire page.

I have 2 simple data entry cells in a one page. one sheet spreadsheet.

Those cells affect 3 result cells, and they affect 2 columns of numbers that are calculated based on the entered data. Again, all on the same page.

Using the Arrange/Lock feature, I seem to be able to lock the entire page, not sections of it. If I select 1 or a group of cells and then go Arrange/Lock, it locks the entire page, preventing the user from redesigning my page, but also preventing them from entering data to get a calculated result.

Hi exMacEmp,

What you are calling a 'page' is a sheet. A sheet is a canvas that can have any number of tables, text boxes and objects on it.

The suggestion is to have an unlocked table for data entry and a locked table for your calculaions.

quinn

You can lock tables but NOT indivicual cells. It's best to group things together by whether they are allowed to be changed, then lock them as groups.

Wayne,

I previously could lock tables in my Numbers tables in my Spreadsheets by tapping the top left corner and it would show up as an option to lock it. As of Numbers 2.0 (noticed today), I get the option to unlock tables, but not to relock them after making the corrections.

Any thoughts?

Thanks!

Yoiu might ask the folks in the iOS discussion area. Better chances of finding someone there who has seen this problem than here in the Mac area.

Jerry

To lock an entire table, select a cell in it and go to the Arrange inspector. There's a button at the bottom to Lock.

Hi Vincent,

Thanks for that. If I know it I had forgotten.

quinn