I cannot delete a row in Excel

[Erkan Mali]

At my workplace, I am working an excel file. I need to delete row completely. When I choose remove this row (not delete contents), it only deletes the content and the said row stays there. I want to remove the whole row altogether so that the rows below could move up but they don’t.

Also when I delete the contents of any row, I cannot perform Ctrl+Z. In other words the excel works in a weird way. Plus I tried this in other users and the issue persists.

 

[Phillip Corcoran]

May be this will help:

https://support.office.com/en-gb/article/insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246?redirectSourcePath=%252fen-us%252farticle%252fInsert-or-delete-cells-rows-and-columns-B6982F0B-A707-4282-A59D-65A3B47FAFA3&ui=en-US&rs=en-GB&ad=GB

 

[Alabalcho]

Does this happen with freshly-created Excel file?
Are there any customizations to that file (macros, functions etc)?
Are there any protections set for that sheet / file?

 

[Erkan Mali]

@Alabalcho I tried in a new excel file and the problem does NOT persist. Only that file has an issue. There are no protections or macros in that excel. Also I was able to delete the rows whenever I wanted. The issue only started to happen that. I had to copy paste the worksheet on to a new file. It seems there is no solution.

 

[Alabalcho]

Can you just copy whole contents into a new file, and replace the original?

 

[gsp.gr81]

Maybe you locked the sheet?
The reason why you would still be able to make changes on the cells is because they might be unprotected, but the delete row/column protection options are on so the delete row option is greyed out.

 

[palakbisht]

At my workplace, I am working an excel file. I need to delete row completely. When I choose remove this row (not delete contents), it only deletes the content and the said row stays there. I want to remove the whole row altogether so that the rows below could move up but they don’t.

Also when I delete the contents of any row, I cannot perform Ctrl+Z. In other words the excel works in a weird way. Plus I tried this in other users and the issue persists.

hi,

• Select a cell in the row that you wish todelete.
• Right-click and select "Delete" from the popup menu.
• When theDelete window appears
• select the "Entire row" option and click on the OK button.