Increase Indent and Decrease Indeat icon not working on a protected sheet

Question

These two icons do not work on the protect sheet. I checked everything in the protect options. Format cells is allowed.

This cell is not locked.

I also found that even the cell is locked and the sheet is protected, I am still able to change to indent in the Format Cells... dialog.

But the icon the toolbar are not working as long as the sheet is protected, no matter the cell is locked or unlocked. I tested on a brand new excel file, no vba macro. Test on two computers. The version is Microsoft® Excel® for Microsoft 365 MSO (Version 2110 Build 16.0.14527.20270) 64-bit Please help. Thanks.

Answer 1

Hi,

I can reproduce this behavior in my Excel: Microsoft® Excel® for Microsoft 365 MSO (Version 2401 Build 16.0.17231.20084) 64-bit, this behavior is indeed somewhat unrealistic.

You can try to give a feedback to Microsoft about about this behavior in Excel:

https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11

Microsoft values your opinion. Your feedback goes directly to our engineers and helps us shape the future of Microsoft products and services for all our users.

---

If the response is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.