MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

"Can not shift objects off of sheet"

  Asked By: Cesar    Date: Jan 09    Category: MS Office    Views: 1599

I am still not able to solve this problem:

This is an Excel question:

I attempt to hide several columns in excel and an error reports back

"cannot shift objects off of sheet".

I examine visually the columns and there is nothing visible. I do
have pictures and clip art, however these are not in the area or even
on this sheet. It must be a text box or other that I cannot see.

I have used the go to function - special options to highlight all
objects. It does not show any that would cause this problem.

Does someone have an idea about this problem?



1 Answer Found

Answer #1    Answered By: Darrel Nelson     Answered On: Jan 09

I was able to resolve the error. It was a comment, the balloon is
considered an object and it was to the right of the columns  being
hidden. Changed properties of objects  to move and resize with cells
and this fixed the error  message.

Didn't find what you were looking for? Find more on "Can not shift objects off of sheet" Or get search suggestion and latest updates.