+ Reply to Thread
Results 1 to 4 of 4

Cannot shift objects off sheet when hiding columns

  1. #1
    Forum Contributor
    Join Date
    10-06-2015
    Location
    Leeds, England
    MS-Off Ver
    365 Version 2302 Build 16.0.16130.20942
    Posts
    130

    Cannot shift objects off sheet when hiding columns

    I'm trying to hide all the columns to the right of a table, but the sheet in the workbook is not allowing it. I've selected all the columns to the right and deleted them, cleared them, checked that all objects are displayed in the excel options, and that no comments are in the cells. The sheet is also unprotected.

    There's literally nothing in the cells in the columns I want to hide and yet I can't hide them.

    I can't share the workbook due to confidential information, but has anyone else experienced this? Excel 2013

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: Cannot shift objects off sheet when hiding columns

    If you goto File>Options>Advanced... under Display options for this workbook what is selected under 'For objects, show:'?

    If it's 'Nothing (hide objects)' that could be the problem and you should be able to fix things by selecting All.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Cannot shift objects off sheet when hiding columns

    What do you mean when you say that the workbook is not allowing it? Are you getting an error?

    Maybe clear any confidential data then upload the workbook for us to take a look.

  4. #4
    Forum Contributor
    Join Date
    10-06-2015
    Location
    Leeds, England
    MS-Off Ver
    365 Version 2302 Build 16.0.16130.20942
    Posts
    130

    Re: Cannot shift objects off sheet when hiding columns

    Never mind, I found an ActiveX object someone had hidden in the sheet https://www.excelforum.com/images/smilies/mad.gif

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Cannot Shift Objects Off Sheet
    By Gurdip in forum Excel General
    Replies: 5
    Last Post: 05-09-2012, 10:41 AM
  2. Cannot shift objects of sheet
    By steliosL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-29-2009, 10:14 PM
  3. Hiding Columns - Can't shift objects off sheet
    By dave12345gillian in forum Excel General
    Replies: 8
    Last Post: 11-02-2008, 08:43 AM
  4. [SOLVED] [SOLVED] unable to hide columns -"can not shift objects off sheet" shows
    By Pinaki in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2006, 10:20 AM
  5. [SOLVED] when hiding columns mess: "cannot shift objects off sheet"
    By KM in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 09:10 PM
  6. [SOLVED] cannot shift objects off sheet
    By Tim Wallace in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-17-2005, 04:05 PM
  7. [SOLVED] cannot group columns - get "cannot shift objects off sheet" help!
    By centurion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2005, 09:06 AM
  8. cannot group columns - get "cannot shift objects off sheet" help!
    By jeff in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2005, 06:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1