'Cannot shift objects off sheet"

[MSawicki]

I am tryingto hide columns of data and I get this message. What is this and
how do I fix it?

 

[David McRitchie]

Usually it means you are trying to insert sufficient rows or columns that you would
cause data to be pushed off of the worksheet. Examples are

You already have data in the last row or last column and try to insert a row
or a column.

You try to copy an entire worksheet at the end of the data region of another
worksheet.

 

[Gord Dibben]

Or you may have Comments interfering with the process.

"Cannot shift objects off sheet" error message when you hide columns in Excel"

http://support.microsoft.com/default.aspx?scid=kb;en-us;211769

Gord Dibben Excel MVP

Usually it means you are trying to insert sufficient rows or columns that you would
cause data to be pushed off of the worksheet. Examples are

You already have data in the last row or last column and try to insert a row
or a column.

You try to copy an entire worksheet at the end of the data region of another
worksheet.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I am tryingto hide columns of data and I get this message. What is this and
how do I fix it?

 

[David McRitchie]

thanks I was thinking the other cause was protected cells but
I couldn't get that to fail. And comment boxes are shapes,
and that also applies to types of shapes.