Forum Discussion

Tom_M_1969's avatar
Tom_M_1969
Copper Contributor
Jan 14, 2022
Solved

Locking cells in Excel Online? Is it possible?

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...
Excel for web
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Jan 14, 2022

    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.)
mrobinsorcon's avatar
mrobinsorcon
Copper Contributor
Jan 10, 2023

NikolinoDE 

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

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jan 10, 2023

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 🙂

Resources