Deleting rows on a protected worksheet

[Giordano Bruno]

I open a new workbook and protect the sheet with no password allowing insertion and deletion of rows. Home>Insert allows rows to be inserted, but Home>Delete is greyed out.
There is no vba code and no addins. Does anyone have an explanation

 

[duggie33]

Based on this...

Deleting rows in a protected sheet in Excel

I am using Microsoft Excel 2016.I created a document, entered data in it and protected it from the review tab.The options that I allowed for anyone who gets..

techcommunity.microsoft.com

I believe that it is because the cell in the row you are trying to delete are locked.

Hope that helps,

Doug

 

[Giordano Bruno]

Thanks Duggie. Have you tried this yourself? Even if all of the cells are unlocked, I still have the same behavior. Also, while the sheet is locked, I am still able to select the row and remove it with the short cut Alt-e > d, so there is clearly no restriction applying to the removal of rows on the locked worksheet; I just can't do it using the ribbon commands. I'm using Excel 365, windows 10 btw.

 

[duggie33]

It worked for me. I unlocked the cells for about 10 entire rows, protected the sheet, and was able to delete those rows. I right clicked and hit delete.

Doug

 

[Giordano Bruno]

Hi Duggie. Thanks for that, but the point is that the ribbon does not allow this. As you say, there is no problem removing the rows, so what is the reason that the ribbon solution (Home > Delete> Rows is greyed out.

 

[duggie33]

You will have to ask Microsoft.

 

[duggie33]

I just checked, on rows where I "unlocked" all cells in the entire row, protected allowing Insert and Delete Rows, I can delete the entire row from the right-click menu or the ribbon.

 

[Alex Blakenburg]

Hi Duggie. Thanks for that, but the point is that the ribbon does not allow this. As you say, there is no problem removing the rows, so what is the reason that the ribbon solution (Home > Delete> Rows is greyed out.

I can only reproduce this by "not" selecting the entire row.
Are you sure you have the whole row selected either by clicking in the left margin or pressing shift+spacebar ?