Forum Discussion
Excel will now allow me to delete a single cell without deleting the row.
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...
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.