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 edit unprotect excel sheet
how to edit unprotect excel sheet without password
how to unlock for editing excel file
how to open and edit excel sheet online
how to unlock locked for editing excel file
how to unlock excel spreadsheet for editing without password
how to open and edit excel files without office
how to open and edit excel file on iphone
how to open and edit excel file in python