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
So here we are talking about few features which can protect your excel sheets, projects, dashboards etc. Let’s have a look:
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
Few Excel Tips 1. CHANGE DIRECTION WHEN YOU PRESS ENTER Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very…
How to Hide Ribbon &Formula bar in excel? While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and…
Remove Duplicates in Excel Highlight/Select the Column A, similar to shown in below screenshot: Go To “Data” tab on Menu Bar and click on “Remove Duplicates” as shown below: Once you click on “Remove Duplicates”,…
What is Pareto Chart? Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of…
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…
In layman language, this chart divides the data into multiple range groups with same interval i.e. 1-5, 5-10… and then plot the data into these groups to find the distribution among these group. So that you may understand, what are the major areas which has large impact or your major data fall. This helps the user to understand the nature of your data