I am creating a spreadsheet for reporting numbers (statistics) with each branch reporting in a separate tab and to tab showing the totals. To better protect the process of reporting and avoid accidental deletion of formulas, I have a couple of questions:
1. Can I protect the specific cells, that contain formulas, while allowing the user access to adding the numbers/values that are to be added on a monthly basis?
2. Can I restrict who can enter numbers/values to which tabs/sheets? These will be different individuals for each tab.
3. Can I, on top of these other restrictions/protections, add a separate password for the file itself?
Thanks.
Bookmarks