Forum Discussion
Excel will now allow me to delete a single cell without deleting the row.
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.
Jel2273 You are the man! I was having the same issue. Converting to range resolved my issue! Thanks!!!
DTrain1961or the woman!
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
