With Protect Sheet and Protect Workbook, a user can protect a worksheet or workbook so that only a person who knows the correct password can access them. However, what if we want to protect only part of the worksheet? Also, if more than one user is simultaneously working on the document, is it possible to grant them different access rights? Can the system administrator use domain rights for this purpose? Meet the Allow Users to Edit Ranges option.
At every company there are certain data that should be kept secret. Also, sometimes we do not want everyone to be able to edit the document, especially when it comes to corporate reports that should have a unique form. Since Excel is a tool frequently used for budgets or as a tool for interpreting business reports, it’s important to know how to protect individual worksheet elements, the structure of the workbook, and the workbook as a whole.
Tracking changes to a document is used when multiple users are working in its editing. It is done so that we can see which user has made the changes, so that we can remove errors or make other changes that will improve the final version. This option only applies to shared documents. Even if we did not share it, after activating the tracking changes option it will become a shared document.