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...
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.
JKPieterse I've done that too, but for the number of individual cells I was deleting that was too time consuming.
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