When I move a table column to another position in the table, I keep getting an error message telling me that "Excel can't insert new cells because it would push non-empty cells off the end of the worksheet."
I can confirm that the table column itself is selected and is being dragged to the new location and not just moving the cells contents to overwrite what's already there.
The most common solution I'm aware of is to delete content from what may appear to be an empty cell. I've done that several times, but to no avail.
I really don't want to rebuild this worksheet, so is there another solution I can try?
I can confirm that the table column itself is selected and is being dragged to the new location and not just moving the cells contents to overwrite what's already there.
The most common solution I'm aware of is to delete content from what may appear to be an empty cell. I've done that several times, but to no avail.
I really don't want to rebuild this worksheet, so is there another solution I can try?