Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change calculations, sheets and sometimes, finish the essence of the project
Once you click on “Protect Sheet”, below window will appear:
So here is small glimpse of protecting excel sheet:
Whenever two users want to work on one excel sheet at the same time, we use “Share Workbooks” option. This feature is amazing and allow multiple users to work on it at the same time:
Below window will appear on your screen. So there are two tabs at the top:
Note: Few things to remember while using this “Shared Workbook” Option:
When you are tracking changes, it might be possible that people may delete the changes being done in the sheet however “Protect Workbook” helps to prevent users to turning off the changes. It just help to save the “Track Changes” data
Hope you like this article. You may comment here, if you have any doubts. We are here to help you
How to Create a Pivot Table? Pivot Tables in excel is backbone of data analysis in excel. If you want to perform various analysis in excel, then I would suggest, learn this amazing excel feature…
Want to learn how to unprotect Excel worksheet? Follow this simple guide to master this important skill in Excel. You can protect an Excel worksheet with or without a password. This helps keep your data…
Introduction Calculate Percentage in Excel :-The term “per cent” comes from the Latin per centum, meaning “by the hundred.” A percentage is a way to show a part of something out of 100. You can…
Video: How to Hide Worksheet in Excel? Hide Sheet in Excel When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any…
How to Compare TWO Columns in Excel? Comparing Columns in Microsoft excel is much often feature that is used while managing database. We have many ways to compare the columns in excel and can be…
How to Get RGB Codes of a Color? Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this through…