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 sheet mac
how to unlock excel sheet macro
how to unprotect excel sheet mac
how to unprotect excel sheet macro
how to unlock protected excel sheet mac
how to get excel for mac
how to get excel for mac free
how to open excel spreadsheet on mac
how to open excel macro file
how to open excel sheet in macbook