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

Question:

Question: Help tidy this sheet

Can anyone help me tidy up a speadsheet I've completed to track my overtime

Basically, I'm happy with the format but...

When you click on a cell, the column and row details become visible

I would like them to remain hidden and the cells to be just "input only"

I assumed I could protect the cells but am not having much luck


User uploaded file

iPhone 7, null

Posted on

Reply
Question marked as Solved
Answer:
Answer:

Hi hays,


This is the way Numbers works.


When you select any cell on a table, that table becomes active. An active table displays its row and column reference tabs.


A Numbers table may be locked (as may other objects).


A locked table cannot be moved, nor will it accept any input.


A cell is part of a table, not an object, and cannot be locked (except by locking the table).


Numbers recommended practice includes separating input cells and other (fixed data and result cells) onto different tables, and locking the tables containing no input cells.


One means of protecting cells on an unlocked table is to place one or more transparent objects (eg. a Shape) in front of the cells needing protection, and locking that object. There are shortcomings to that method, and I have not seen a recent recommendation regarding using it.


Regards,

Barry

Posted on

Page content loaded

Question marked as Solved

Mar 10, 2018 10:26 PM in response to hays60 In response to hays60

Hi hays,


This is the way Numbers works.


When you select any cell on a table, that table becomes active. An active table displays its row and column reference tabs.


A Numbers table may be locked (as may other objects).


A locked table cannot be moved, nor will it accept any input.


A cell is part of a table, not an object, and cannot be locked (except by locking the table).


Numbers recommended practice includes separating input cells and other (fixed data and result cells) onto different tables, and locking the tables containing no input cells.


One means of protecting cells on an unlocked table is to place one or more transparent objects (eg. a Shape) in front of the cells needing protection, and locking that object. There are shortcomings to that method, and I have not seen a recent recommendation regarding using it.


Regards,

Barry

Mar 10, 2018 10:26 PM

Reply Helpful (1)
User profile for user: hays60

Question: Help tidy this sheet