Are you unable to modify cells because they are locked?

Heres how to lock or unlock cells in Microsoft Excel 365.

FAQ

Why is Protect Sheet grayed out?

Excel Header

If its a shared workbook, Protect Sheet may be grayed out.

Unshare it by selecting Review > Share Workbook, then deselectAllow changes by more than one user….

Otherwise, multiple worksheets are selected.

Excel Format Cells option

Right-click any tab, then select Ungroup Sheets.

Excel locked setting

Excel protect sheet

Excel Format Cells option

Excel locked setting

Excel protect sheet