Jan 14 2022 07:19 AM
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.
Jan 14 2022 07:41 AM
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
Jan 14 2022 07:41 AM
SolutionYou 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:
May 25 2022 02:37 AM
If you want to keep your data locked away from others, you can do so using Microsoft Excel Online.
For more detailed article you may check out this blog post: https://www.dancingnumbers.com/how-to-lock-cells-in-microsoft-excel/
May 25 2022 03:00 AM
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)
Sep 10 2022 10:54 PM
@Hans Vogelaar Only works on desktop version
Oct 23 2022 05:36 PM
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.
Jan 10 2023 07:27 AM
When can we expect the locking feature to be added to Excel for the Web?
Jan 10 2023 12:43 PM
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 :)
Jun 08 2023 12:40 AM
Jun 16 2023 04:21 AM
Sep 01 2023 06:56 AM
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?
Apr 12 2024 07:16 AM
Jan 14 2022 07:41 AM
SolutionYou 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: