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.

Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.

Majestic software khs for mac. I protected my worksheet, except I left a few cells open to edit via the 'Allow users to edit Ranges' button. When I send this spreadsheet to others. The PC users can edit those few designated cells (good), but the mac users can't (bad). It's like the Mac version of excel is locking the entire sheet without regard to the few cells I said to leave editable.

Click the Protection tab, and then clear the Locked check box. Clear the Lock text check box if it is present. Updates for adobe acrobat xi pro. Select the cells that contain the formulas. On the Format menu, click Cells, click the Protection tab, and then select the Hidden check box.

To make matters worse, if the mac user opens the spreadsheet in Apple Numbers, nothing is locked at all. One of my mac users is on version Mac Excel 14.6.0. When I help him unlock the sheet, you can see there's no button to specify which cells should be editable. That makes me think the mac version of excel doesn't have this feature.? I'd show you a screenshot but I don't see where I can attach a picture to this thread? Is this a known issue? What can I do about it?