How to hide more columns

Tamilselvan.K · Feb 5, 2009

When i am trying to hide 192 columns in a worksheet, it says, "cannot shift
objects off sheet?". How to overcome this, pls help me.

Daniel.C · Feb 5, 2009

Looks as if you have some shapes in that area.
Daniel

eksh · Feb 5, 2009

Because you have object which cannot move or size with cell.

Gord Dibben · Feb 5, 2009

Have a read here.

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

Cell Comments are usual source of problem.

Gord Dibben MS Excel MVP

Hiding Columns	2	Oct 16, 2009
Unable to hide columns	1	Nov 3, 2008
Problem in hiding columns	2	Aug 29, 2008
Getting error message when trying to hide a column	2	Nov 10, 2008
Cannot shift objects off sheet?	2	Jun 11, 2008
Columns appearing from nowhere, formatting going weird	0	Aug 2, 2023
"cannot shift objects off sheet" error	8	Mar 28, 2013
Margins on Word document which will not let me move them using the ruler arrows	2	Dec 4, 2017

Ask a Question