Jul 08 2019 05:27 PM
For some reason, when I try to delete any cell it will delete the entire row and move the data from below into that space. Please help me fix this. I cannot see that the rows are grouped or protected and everything looks normal.
Jul 09 2019 02:24 AM
Jul 09 2019 02:40 AM
Hi @Amesser
You can delete a single cell without deleting entire row / column. Please see attached screen shot.
Thanks
Tauqeer
Jul 09 2019 08:22 AM
@Jan Karel PieterseIt really goes for any cell within excel. I've tried creating a new spreadsheet and it does the same thing. What I've been doing is: home tab, cells section, selecting the delete cells button.
Jul 09 2019 11:09 AM
Jul 09 2019 11:14 AM
@Jan Karel PieterseIt is not protected. How do I look if there is content underneath the table?
Feb 12 2022 10:16 AM
I am also sad about this new change. I used to be able to delete text in a field, and I'd have the option to move all text around it to the left, right, up, and down.
Here is why this option is essential.
I clean data for a living, and someone inevitably cuts and pastes their data into a Sharepoint document, and the field they cut and pasted doesn't match the master document. I used to sort to find the pattern and cut out the bad cells, and the other text would move to the correct location. As of a couple of weeks ago, this option has disapeared.
PLEASE put this option back; I noli=ong have a workflow to do my job.
Nov 10 2022 08:25 AM
@Amesser I had the same issue. Here is how I resolved it. On the top Tool Ribbon, Table Tools - Design, click on "Convert to Range". That should solve the problem.
Nov 11 2022 02:22 AM
@Jel2273 Rather than removing the table (which may wreck all sorts of things in an Excel file), if I need to shift a number of cells up (or down) in a table, I simply copy the cells beneath that area and then paste one or more rows higher (or lower). You do have to remember to clear the duplicated values that this causes at the bottom (or at the top) of the copied range though.
Nov 23 2022 09:29 AM
@Jan Karel Pieterse I've done that too, but for the number of individual cells I was deleting that was too time consuming.
Nov 23 2022 11:27 AM
@Jel2273 alternatively, you could also resize the table (make it less rows) so the past you need to keys is no longer inside that table. Then after the delete, size the table back to its original size
Feb 04 2023 03:29 PM
@Jel2273 You are the man! I was having the same issue. Converting to range resolved my issue! Thanks!!!
Apr 08 2024 07:27 AM
@Jel2273 - this is EXACTLY what I needed! I had a spreadsheet that I had formatted with alternating row shading. It kept wanting to delete an entire row or column. This corrected it! Thanks very much!
Apr 08 2024 07:38 AM
@DTrain1961or the woman!