STEP 4: Select the Protection tab and Un-check the Locked box STEP 3: Press CTRL+1 to bring up the Format Cells dialogue box In the end, only the cells containing formulas will remain locked! So, we need to select the cells containing constant values and unlock them. STEP 2: Select the Constants box and press OK (this highlights all the non-formula cells)īy default, all the cells in Excel are locked. STEP 1: Press the Go To Special shortcut CTRL+G. Watch it on YouTubeand give it a thumbs-up! If you have a workbook with lots of formulas and you want to protect those formulas from being amended by other people who share your workbook, then you can even lock the cells! Two methods on how to protect formula cells in Excel are: At those times, hiding or protecting the formula will become of utmost importance. There may be situations when you have to share these files with a colleague or boss. So, it is important to know how to lock formula cells in Excel! This may lead to errors that may be difficult to spot later. In Excel, you can easily create and edit formulas using the formula bar or double-clicking the cell itself.īecause it is that easy to edit a formula, you can accidentally enter the delete button or make any unwanted change in a formula. In this blog, you will learn two methods on how to lock formula cells in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |