When I try to hide certain columns on one of my excel worksheets I get the
error message, "cannot move objects off sheet". As far as I know the only
thing in my columns are text and some simple formulas. How do I fix this so
I can hide columns I don't want to see? My sheet is not protected, neither
are any cells on my sheet.

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

kadmin wrote:

When I try to hide certain columns on one of my excel worksheets I get the
error message, "cannot move objects off sheet". As far as I know the only
thing in my columns are text and some simple formulas. How do I fix this so
I can hide columns I don't want to see? My sheet is not protected, neither
are any cells on my sheet.

--

Dave Peterson

Thanks, but I have no comments and merged cells don't seem to be the issue.
I have merged cells every three columns across the entire worsheet and most
of them I can hide. A few of the columns for some reason I cannot hide. Do
you have any other suggestions?

"Dave Peterson" wrote:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

kadmin wrote:

When I try to hide certain columns on one of my excel worksheets I get the
error message, "cannot move objects off sheet". As far as I know the only
thing in my columns are text and some simple formulas. How do I fix this so
I can hide columns I don't want to see? My sheet is not protected, neither
are any cells on my sheet.

--

Dave Peterson

Just what was in that KB article.

kadmin wrote:

Thanks, but I have no comments and merged cells don't seem to be the issue.
I have merged cells every three columns across the entire worsheet and most
of them I can hide. A few of the columns for some reason I cannot hide. Do
you have any other suggestions?

"Dave Peterson" wrote:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

kadmin wrote:

When I try to hide certain columns on one of my excel worksheets I get the
error message, "cannot move objects off sheet". As far as I know the only
thing in my columns are text and some simple formulas. How do I fix this so
I can hide columns I don't want to see? My sheet is not protected, neither
are any cells on my sheet.

--

Dave Peterson


--

Dave Peterson

I deleted all the comments on the worksheet and now I can hide the columns I
need to. Thanks.

"kadmin" wrote:

Thanks, but I have no comments and merged cells don't seem to be the issue.
I have merged cells every three columns across the entire worsheet and most
of them I can hide. A few of the columns for some reason I cannot hide. Do
you have any other suggestions?

"Dave Peterson" wrote:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

kadmin wrote:

When I try to hide certain columns on one of my excel worksheets I get the
error message, "cannot move objects off sheet". As far as I know the only
thing in my columns are text and some simple formulas. How do I fix this so
I can hide columns I don't want to see? My sheet is not protected, neither
are any cells on my sheet.

--

Dave Peterson