MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help. I cant insert a column

Posted by Bill on March 02, 2000 11:19 AM

I am trying to insert a column on a spreadsheet and a message box pops up saying that i cant shift non blank cells off a worksheet.
it wont let me do it.
any suggestions. ??


Posted by Chris on March 02, 2000 11:43 AM


The problem is that you have something in the last column of the worksheet. It could be either text or formatting. If you formatted an entire row a particular way, you could end up with this problem.