Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel

Use Excel to process and calculate data to help you work more efficiently. But when sharing data with others, you don't want to be edited by other formulas. The following article will help you know how to lock formulas in Excel, you track it!

Step 1: Open the sheet containing the formula to lock, select all the sheets with Ctrl + A key combination . Then right-click and choose Format Cells .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 1

In the Format Cells dialog box, click the Protection tab , deselect the Locked item, and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 2

Step 2: You can press Ctrl and manually select the cells containing the formula to lock, or if you want to select all the cells containing the formula in the sheet, then select Home -> Find & Select -> Go to Special (or Ctrl + G and select Special ).

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 3

In the dialog box Go To Special you select Formulas and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 4

Step 3 : After clicking OK , all the cells containing the formula in Sheet are selected, you just need to click Home -> Format -> Format Cells .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 5

In the Protection tab, click Locked to lock and click OK . If you want to hide the formula, click on Hidden .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 6

Step 4: Select Review -> Protect Sheet (or Home -> Format -> Protect Sheet ) to open the password setting dialog.

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 7

The Protect Sheet dialog box appears, enter the password in the Password to unprotect sheet and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 8

Confirm the password and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 9

So you locked the formulas in the sheet, to unlock you go to Review -> Unprotect Sheet (or Home -> Format -> Unprotect Sheet ) then enter the password into the Unprotect Sheet dialog and click OK to Unlock recipe.

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 10

The article on detailed instructions on how to lock formulas in Excel, you just need to follow the steps to lock the formula as you like. Good luck!

5 ★ | 2 Vote

May be interested

  • How to name, comment and protect cells in ExcelHow to name, comment and protect cells in Excel
    instructions on how to name, note and protect cells in excel. 1. name the data cell. - normally, the data cell with the default name is the combination of the column and row order that makes up the cell. for example, cell b5 is named b5. - to change the name for a cell, do as follows: + click to select
  • How to create an Excel formula in Notepad ++How to create an Excel formula in Notepad ++
    when entering excel formulas in notepad ++, there will be additional features highlighting, highlighting, and suggestion. the following article will guide you how to set up an excel input formula in notepad ++.
  • Merge cells in ExcelMerge cells in Excel
    the most common reason to merge cells is to format and center headers. this tutorial will show you how to merge cells in excel, although you shouldn't merge them unless you really need to.
  • Steps to lock columns in ExcelSteps to lock columns in Excel
    locking columns in excel with a password helps you protect columns, prevent others from changing column content or editing columns, affecting all data of the table.
  • Complete tutorial of Excel 2016 (Part 5): Basics of cells and rangesComplete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
    whenever you work with excel, you will need to enter information - or content - into the cells . cells are the basic building blocks of a spreadsheet. you will need to learn the basics of cells and cell contents to calculate, analyze, and organize data in excel.
  • How to split cells, combine cells in ExcelHow to split cells, combine cells in Excel
    how to split cells, combine cells in excel. on excel spreadsheets, many times you need to split cells, merge cells to fit the data you need to enter. you can combine two or more cells together using excel's built-in functions or use visual basic to merge
  • How to calculate and color blank cells in ExcelHow to calculate and color blank cells in Excel
    counting and coloring blank cells in excel will rely on excel functions and conditions to perform.
  • How to display formulas and print formulas in ExcelHow to display formulas and print formulas in Excel
    display formulas and print formulas in excel so you can see the formula directly in the data cell, not see the results anymore. to be able to display and print the formula so please follow the instructions below of tipsmake.com.
  • A complete guide to Excel 2016 (Part 14): Create complex formulasA complete guide to Excel 2016 (Part 14): Create complex formulas
    after learning about the recipe in excel 2016, tipsmake.com continues to guide you how to create more complex formulas. invite you to consult!
  • Lock one or more data columns on Excel worksheet - Freeze data in ExcelLock one or more data columns on Excel worksheet - Freeze data in Excel
    to lock one or more data columns in excel worksheet, you do as follows: open the sheet containing the data columns to be locked, then select all sheets by pressing ctrl + a. right-click and choose format cells ...