In this video, you will learn how to lock cells that have formulas in it in Excel.
Excel formulas are easy to create and edit in Excel.
You can easily edit a formula in a cell through the formula bar or directly in the cell.
While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well.
Consider this.
You are going through a worksheet full of formulas and you accidentally hit the delete key, or backspace key, or some other number/alphabet key.
Now you'll be lucky if you're able to spot the error and correct it. But if you don't. it may lead to some erroneous results.
And let me tell you this, errors in Excel have cost millions to companies (read this or this).
The chances of such errors increase multifold when you share a file with colleagues or managers or clients.
One of the ways to prevent this to lock the worksheet, which in turn lock all the cells in the worksheet. However, doing this would prevent the user from making any changes to the worksheet. For example, if you're sending a workbook to your manager for review, you may want to allow him to add his comments or color code cells as his/her feedback.
A better workaround to this is to lock cells that have formulas in Excel.
In this video, you will learn how to lock cells that have formulas in it.
Read More: trumpexcel.com/lock-formulas-...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzitem.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Негізгі бет How to Lock Cells that have Formulas in Excel (Step-by-Step)
Пікірлер: 211