Forum Discussion
Locking cells in Excel Online? Is it possible?
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:
- Unlock the cells that should be editable in the Protection tab of the Format Cells dialog.
- Protect the worksheet on the Review tab of the ribbon.)
Tom_M_1969 at my work we now moved everything to onedrive and use the browser version of excel. Although the locked sheet is in place, on the desktop version when I pressed TAB excel took me to the next unlocked cell andkeystrokes. the locked cells. I did this intentionally as these unlocked input cells pulled info from another sheet.
In the browser locked version the TAB key still navigates to the adjacent locked cell and I have to press TAB or ARROW keys multiple times when I used to be able to do so with one keystroke. So what used to be a couple of dozen keystrokes in a work shift is more 150-200. That lacks efficency. I haven't found a way to fix this issue.