Skip to content Skip to sidebar Skip to footer

How to Protect Cells and Ranges in MS. Excel (Full+Image)

Microsoft Excel is an application from Microsoft that makes it easy for us to create financial reports or other reports. Usually if we use excel, there must be a lot of formulas that we use, because it can help us in doing tasks.

With so many formulas, we definitely want our data to be safe, right? For that we have to protect or lock the cell so that it cannot be edited and remains safe. Although by giving protection to the Excel work is not a guarantee that the data will be safe, but at least it can reduce it. Because by making protection in Office Excel, in the end, protection can be uprooted.

And usually the protected Excel data is important data in which there are many functions (formulas). It is feared that if it is not protected then these functions will be deleted so that the application does not run normally. Then, how do you protect or lock cells and ranges?

Well, this time I will share about how to protect or lock cells and ranges so they can’t be edited easily. how do? Just follow the steps on how to protect cells and ranges in Ms. Excel below yes.

How to Protect Cells and Ranges in MS. Excel

Basically all cells and ranges are locked by default when you enable sheet protection. For that the first step you need is to disable it first in the following way:

1. First, please block or select all cells on the sheet that are related to shortcut Ctrl+A or Click the triangle icon in the upper left corner the sheets. Then, please click “Format Cells”. As in the image below.

how to protect cells and ranges in Ms.  Excel

2. Then, will appear Format Cells dialog. In this dialog box. please select or activate Protection tab. Then, please uncheck the Locked option. Then, please click Ok. As in the image below.

locked

Alternatively, for a shorter and easier way you can disable the protection of all cells in the following way:

1. Please block or select all cells on the sheet related to shortcut Ctrl+A or Click the triangle icon in the upper left corner the sheets.

how to protect cells and ranges in Ms.  Excel

2. Then, please click Home Tabs, then click “Format”. Then, please click “Lock Cell”. As in the image below.

lock cell

At this stage the main goal is to disable the cell lock setting for all excel cells on the assembled sheet.

Second step, after setting all unprotected cells (unlocked cells) is to activate the lock cell settings on some specific cells that you need. The method is as follows:

1. Please block/selection sell or range what do you want. As in the image below.

how to protect cell and range

2. Then, please right click, then select menu Format Cells. As in the image below.

cell format

3. Then, will appear Format Cells Dialog Box. Please click Protection tab. Then, on the Protection tab, make sure the option Locked ticked. Then, click Ok. As in the image below.

locked

For an easier way you can use the menu Lock cell as before in Tab Home–Group Cell–Format.

Well, how? The method is quite easy and very simple right? Now we can lock or protect the cells and ranges we want. So, our cells become more secure, especially if there are many formulas in our cells.

That’s how to protect cells and ranges in Ms. Excel that you can try. If this article can help you, please share it with your friends so they also know how to protect cells and ranges in Ms. Excel.

Post a Comment for "How to Protect Cells and Ranges in MS. Excel (Full+Image)"