Using Locked Tables In Mac Numbers

You can't lock individual cells in Numbers, but you can lock entire tables. By designing your spreadsheet well, or making alterations to an existing spreadsheet, you can only have exactly the cells you want as editable.

Comments: 2 Responses to “Using Locked Tables In Mac Numbers”

    4 years ago

    Good video. Another technique I use to let the user know what cells are editable and which are not is color fill the cells. Red no, green yes. Doesn't prevent it but it shows intent.

    4 years ago

    This was extremely helpful, thank you! I've been working in Excel and Google Sheets forever, and I struggle to replicate some of the things in Numbers that I take for granted in the other apps. This helped a lot.

Comments Closed.