'Cannot shift objects off sheet"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tryingto hide columns of data and I get this message. What is this and
how do I fix it?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top