How to protect, lock or lock multiple cells and formulas in Excel at the same time

Who I am
Marie-Ange Demory
@marie-angedemory
EXTERNAL REFERENCES:

vgr.com gamedesigning.org Reddit.com

Author and references

There are tons of users working with Microsoft programs, these programs are excellent for many office jobs. Excel, among its functions, helps work with numbers and information grouped in lines.

This Microsoft program has several functions requested by users, such as the code function or even some formulas that must be used within the spreadsheet. Since it is so necessary, many people are looking for ways to manage it al better.



This highly requested and feature-rich program can be installed on various versions of Windows. For example, in the latest version of Windows 10, it can also be obtained with its updates. This article will show how within Excel you can correct, block or protect a number of cells and formulas at the same time.

Can cells be locked in Excel?

When they started working with this program, many noticed that after placing a title and downloading Excel cells, they can lose everything that was previously written there. But can this be prevented? Yes. All you have to do is fix these cells in Excel . You can do this in each of the versions of Excel.

At this point we note the importance of knowing how to use useful programs such as Excel, belonging to the number of programs provided by Microsoft Office. These programs are extremely necessary to perform any work from your computer.

Lock cells in Excel sheets

The reason some users lock cells is because it's useful continue to have the title visible without losing what has already been written , as mentioned above. It should be noted that these locking functions can only be performed according to certain rules.



Read How to download INSTAGRAM for PC for free - Official (Example)

First, only those who manage the spreadsheet can lock or unlock it. Second, the owner can also continue to edit Excel cells . And thirdly, those who modify these spreadsheets will be able to see the locked cells, however they will not be able to modify them or change the data already established in them.

In Excel tools, the columns cannot be locked if they are for attachments . And if a row has already been frozen, it will have an icon at the top of the row that will openly show that it has been frozen. These steps provide convenience for those who are working with spreadsheets, as they will already be warned that those cells cannot be edited.

How to repair or freeze multiple cells and formulas?

Now a series of steps will be mentioned which will allow you to freeze or fix these Excel cells. So they will be frozen when working on the spreadsheet.

Step 1

The first thing to do is open the document where you want to correct the line. Then the user has to locate the line he wants to correct.

Step 2

After locating it, the user should be directed to the panel option that says View. This can be placed at the top of the toolbar. By clicking it, you can choose where it says "to freeze" . After that, three options will appear on the screen for you to choose from.


Step 3

The user needs to know which of all the options is the most suitable for what they need. For example, if the user clicks for lock the panels , that will give you the opportunity that columns can be locked and also that the lines it chooses to be blocked. In this way, the other cells of the spreadsheet can be moved.


Read How to fix update error 0x800F0986 in Windows Update (example)

To protect the formulas, the user can choose all the cells of a row, with the Ctrl key + 1 a tab will appear showing the word format. And then the user can go to the tab that says "Protect Sheet". There will be a section that will indicate the "Cell format" , by inserting it it will be possible to select all the formulas.


Again, the user must press i Ctrl + 1 keys and now leave a mark where the padlock points inside the section of the sheet that says Protect. This will lock the cells with the formulas.

add a comment of How to protect, lock or lock multiple cells and formulas in Excel at the same time
Comment sent successfully! We will review it in the next few hours.