Forum Discussion

Copper Contributor

Mar 10, 2020

inserting columns

I have been using excell for years and all of a sudden trying to insert column, it comes back saying " can't insert new cells because it would push non-empty cells off the end of the worksheet------", need help

excel

2 Replies

ExcelExciting
MVP
Mar 11, 2020
Hi JohnB735

You might be having data or blank record outside of your table, pls check and delete the same

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.
- Evert_Bolt
  Copper Contributor
  Feb 04, 2021
  ExcelExciting
  
  Hi
  I have similar problem and when using end>home I am taken to last column of the spreadsheet- cell XFD2865. I have tried deleting columns, removing all formats, but nothing works
  I use office 365 and my worksheet uses only up to cell BD10000
  Do you have any suggestion?
  Evert Bolt