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 excel document
how to unlock excel document without password
how to unlock excel document with password protected
how to open excel doc in google sheets
how to unprotect excel document
how to open excel document recovery
how to open excel document in word
how to get excel document back unsaved
how to get excel document out of read only