When I try to add a column in an existing worksheet, I get a message:
"can't insert new cells because it would push non-empty cells off the end of the worksheet------"
when I press end>home, I am taken to last column of the spreadsheet (column XFD) and 2865 rows down to cell XFD2865. I donot not see anything in this cell. I have tried deleting columns, removing all formats, but nothing solves the problem I use office 365 and my worksheet uses only up to cell BD10000
@Evert_Bolt Just to be sure that you have gone through all the options, allow me to ask a few questions. Check Workbook statistics from the Review ribbon. Does it tell you that BD1000 is indeed the last cell in your sheet?
After deleting all columns towards the left of BD, did you save the file, close it and re-open it?
Or perhaps you have accidentally merged all cells of an entire (empty) row. Then, you will not be able insert any columns either.