Locking cells in Excel Online? Is it possible?

[Tom_M_1969]

Microsoft's website claims that the online version of Excel has a feature that will allow you to lock certain cells so that they can't be accidentally overwritten, but it doesn't explain how to do it.

I've been searching for an answer for quite a while, but I can't find any specific info about how to do this. All the tutorials I've seen reference the desktop version of Excel only.

Can anyone shed some light on this? Thank you.

[#2]

@Tom_M_1969 

Lock cells to protect them

Excel for the web can’t lock cells or specific areas of a worksheet.

If you want to lock cells or protect specific areas, click Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet.

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)

[#3 · Accepted solution]

@Tom_M_1969 

You have to apply the protection in the desktop version (for Windows or Mac). If you then upload the workbook to the cloud and open it in Excel Online, the protection will still work.

(Protecting is a two-step process:

1. Unlock the cells that should be editable in the Protection tab of the Format Cells dialog.
2. Protect the worksheet on the Review tab of the ribbon.)

[#4]

Thank you!

[#5]

@Tom_M_1969 

If you want to keep your data locked away from others, you can do so using Microsoft Excel Online.

1. First, open Microsoft Excel Online.
2. Then click the File tab and select Options.
3. On the Options dialog box, click the Protection tab.
4. Under Lock Cells, select the lock type that you want to use.

For more detailed article you may check out this blog post: https://www.dancingnumbers.com/how-to-lock-cells-in-microsoft-excel/

[#6]

@dancingnumbers_J 

Where do you see a "Protection tab" in File > Options in Excel Online?

(There is nothing about Excel Online in the blog page you refer to)

[#7]

@Hans Vogelaar Only works on desktop version

[#8]

Solved this one today.  All the other comments only partially solve our problem.  We had several protected sheets with specific cells locked, but there one sheet would not lock when Excel file open in Teams. Setting the protection was only part of the solution.  

With Excel file open in Teams. Go to Review tab > Manage Protection > (enter password if password protected) > Protect Sheet (on) > Unlocked Ranges (none).

The key was Unlocked Ranges.   
Removing any ranges listed in the Unlocked Ranges section solved it.

Hope this helps someone because it took ages to figure this one out.

[#9]

@NikolinoDE 

When can we expect the locking feature to be added to Excel for the Web?

[#10]

@mrobinsorcon 

A long road has been covered since Excel Online was first presented.

What was not possible then is possible today.

What is not possible today may be possible tomorrow :).

When and if it will be possible, I can't tell you either.

But innovations are always being integrated into Excel Online.

Check out the Microsoft Excel Blog regularly, updates are constantly being presented there.

Subscribe to the Excel Blog to get the latest product announcements and updates :)

[#11]

Even if a lot of time is passed, i've fuond the solution going into "Review" tab and then "Manage protection" (for me it's the last button on the right), from there i can unblock specific ranges when i apply the protection into the sheet.

[#12]

Whilst it's possible using Review>Manage Protection>Unlocked ranges, it isn't as straightforward as the desktop app. In the desktop, you can clear the protection lock for everything then just lock the individual cells, rows or columns that I want to (or vice versa). In Excel online, you have to add the ranges that you do want to be edited. If I just want one cell locked, eg E5, I'd have to add the ranges around it, eg A:D, F:??, 1:4 and 6:??.

[#13]

Hey, I've set up some access premissions like this - opened and created in excel app, apply access rights to all cells but one section allowing user 1 access and not user 2.
On this other section I've allowed user 2 rights to access. All works well in the excel app - however when this is opened through teams, it will always ask for the password to be given.
Is there a way around this?

[#14]

This worked nicely! Thank you!