unlock

How to Lock Cells in Excel

0:00
↔️ ↕️

Timecodes:

Welcome to EasyClick Academy!

My name's Frank and in this short video tutorial

I'll show you how to lock cells in an Excel spreadsheet to protect them from overwriting.

Let's get started!

As you can see there is some data in this table

representing sales made by John, Lucy and Grace within a time span of three months

January, February and March.

The bottom row contains formulas to create the sum of these sales for a particular month.

What we want to do here

is leave the cells containing sales data (those are these cells right over here)

unlocked for editing, so that people could write their own values in these cells,

but, at the same time, lock the cells with formulas, months and names

to make them read-only (or non-editable).

And this is how we do it!

The first step is to check for the option to lock all the cells in the sheet.

You can do so by clicking in the top left-hand corner.

This highlights the whole spreadsheet.

Now right-click, find the Format cells option, and a pop-up window appears.

Check whether the Locked option has been selected on the Protection tab.

Through this all the cells in the sheet can be locked.

Click on OK and we'll move on to the next step.


Related queries:


how to unlock cells for editing in excel
how to unlock for editing excel sheet
how to open editing in excel
how to unlock excel for editing in teams
how to open editor in excel
how to get edit in excel
how to open enable editing in excel
how to open vba editor in excel
how to open macro editor in excel
how to open vba editor in excel mac
how to open query editor in excel
how to open vba editor in excel 2016
how to open vba editor in excel office 365
how to open code editor in excel
how to open vba editor in excel 2007