Excel error message telling me it won't let me move a table column

rizzo93

Active Member
Joined
Jan 22, 2015
Messages
303
Office Version
  1. 365
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?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
What is the name of the table?
Which columns are the first and last table columns?
Which column are you moving?
Where are you trying to move it?
 
Upvote 0
Hi Yongle,
I went out of town unexpectedly over the weekend, so couldn't get to this until now.
Whatever the problem was, it's not happening now. I guess I must have removed whatever Excel was troubled about.
I appreciate you diving in here. Thanks!
 
Upvote 0

Forum statistics

Threads
1,223,956
Messages
6,175,607
Members
452,660
Latest member
Zatman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top