insert column problem

[lindasf]

I’m trying to add 31 more columns to the end of my spreadsheet and
keep getting this strange error message:

“To prevent possible loss of data. MS Excel cannot shift nonblank cell
off the worksheet. Try to delete or clear the cells to the right an
below your data. Then select cell A1 and save your workbook to rese
the last cell used. Or, you can move the data to a new location and tr
again.”

It lets me insert one column, but then it won’t let me insert any mor
columns.

My end columns are blank so I don’t know why I’m getting this erro
message. Thanks.

see attached spreadshee

Attachment filename: calwin training class schedule 062404 - demo2.xl
Download attachment: http://www.excelforum.com/attachment.php?postid=59269

 

[Jim Rech]

If you unhide all the columns in your worksheet you'll see formatting out to
column IV. I'd suggest that you clear the formatting in the range CN1 to
IV22 and then you should be able to insert columns.

 

[lindasf]

Thx much