Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and prevent users to make any editing via “Protect Workbook” Option
So here let’s understand how we can do this:
This will unlock the selected Ranges for editing and user may get restricted to these ranges. It will help you to protect your excel formatting, formulas, headers etc. and everybody can use only specified ranges which you may colour code.
Note: While protecting worksheet, if you uncheck the box “Locked Cells” as below image. It will restrict the user to navigate only on “Unlocked Ranges”
So below gif Image may help you to understand entire process of “Unlocking Specific Range”
Though you can hide Formula Bar but still you can hide formulas without hiding the Formula Bar:
So very simple step, you should follow
Now when you protect the worksheet, it will hide all the formulas where you have ticked this box.
So below gif Image may help you to understand entire process of “Hide Formulas”
Hope you like but still you have questions or any feedback. Please comment below and share with your friends
Merge Cells in Excel Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean…
Excel has built-in options to make graphs, it doesn’t have a heat map feature. However, you can quickly and easily create a heat map in Excel using conditional formatting.
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
The tutorial demonstrates how to find a date any number of days before or after today, counting either all days or only business days.
How to use the compound interest formula in Excel and gives examples of how to calculate the future value of an investment with yearly, monthly, or daily interest. It also shows you step-by-step how to make your own Excel compound interest calculator.