Cannot shift objects off sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seltz - 17 Mar 2008 20:53 GMT

I am trying to hide many columns in a large Excel file. A dialogue box
appears stating: Cannot move objects off sheet. The box prevents me from
hiding any columns. All filters, formatting, hidden panes, frozen panes, etc.
are turned off.

Reply to this Message

Gord Dibben - 18 Mar 2008 00:00 GMT

Any objects like Data Validation dropdowns or Comments?

See this KB Article for possible clues and fixes.

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

Gord Dibben MS Excel MVP

>I am trying to hide many columns in a large Excel file. A dialogue box
>appears stating: Cannot move objects off sheet. The box prevents me from
>hiding any columns. All filters, formatting, hidden panes, frozen panes, etc.
>are turned off.

Reply to this Message

NickyLynn - 18 Mar 2008 14:03 GMT

right click on the column u want to hide. make sure u right click on the top
(meaning the letter) u can select many by pressing the CTRL key. and there
should be a hide and unhide that u can select.

hope that helps!

> I am trying to hide many columns in a large Excel file. A dialogue box
> appears stating: Cannot move objects off sheet. The box prevents me from
> hiding any columns. All filters, formatting, hidden panes, frozen panes, etc.
> are turned off.

Reply to this Message