Failed to hide column with error Message "Cannot shift object off sheet"

    I'm using excel regularly and never found this kind of problem where I wish to hide some columns due to the file has too many information but an error message pop up saying that "cannot shift object off sheet".

    I tried to search online but it didn't help at all.

    Please help me, it is urgent.


    Thank you.

    Re: Failed to hide column with error Message "Cannot shift object off sheet"


    A quick Google for "Cannot shift object off sheet" returns this as number 1 and this with a little more digging...

    There are various solutions depending on your particular circumstances. You're going to have to have a read and see which applies to your situation.

    Re: Failed to hide column with error Message "Cannot shift object off sheet"


    You will need to upload a sample Workbook (after removing/disguising confidential information). Please use Edit Post > Go Advanced > Manage Attachments on your previous post.

    There is no real way to provide any further help without a Workbook that contains the fault.

    Re: Failed to hide column with error Message "Cannot shift object off sheet"


    I tried to manage my file to the lowest kb at 600kb. However, it doesn't match with the edit requirement over here. And then I tried to zip the file but the lowest is 58kb.
    Anyway to attach a larger file at here so that I can show you the error i'm facing?

    Re: Failed to hide column with error Message "Cannot shift object off sheet"


    My company has a private email for suppliers to access. I had cleared off the folder and there is only one email with attachment. The email is sent to you as private message and hopefully you may assist me on this matter.

    Re: Failed to hide column with error Message "Cannot shift object off sheet"


    Forum rules do not permit me to handle attachments for posts in the Free Help section of Ozgrid forums via PM. The purpose of this section of the forums is for open discussion of a problem and the provision of a public solution. If you require direct assistance in this way then you will need to open a thread in HIRE HELP

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login