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.

Any objects like Data Validation dropdowns or Comments?

See this KB Article for possible clues and fixes.

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben MS Excel MVP

On Mon, 17 Mar 2008 12:53:00 -0700, Seltz
wrote:

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.

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!

"Seltz" wrote:

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.