1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Inserting Columns or Rows

Discussion in 'Business Applications' started by floydcojacket, Apr 20, 2011.

Thread Status:
Not open for further replies.
  1. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    When I attempt to insert a column or a row, I'm getting a message from MS Excel:
    "Cannot shift objects off sheet".
    Can someone advise me as to what I must do to correct this?
    Also, what have I done to cause this to happen?
    Thank you for your help.
     
  2. Yorkshire Guy

    Yorkshire Guy

    Joined:
    Dec 9, 2003
    Messages:
    563
    hi floydcojacket,

    I think this is connected with your earlier issue with cell comments.

    I'm now sure you must have your Advanced Options, Display Options for this Workbook- Display Objects set to Hide.

    That option is in the next block below the Display options for Comments.

    lol
    Hew
     
  3. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    You are correct.
    I looked again and the "hide" button was checked.
    I think I've acquired a grimlin since I know I haven't changed these settings myself and I am the only one to use it.
    Whatever the case, problem solved and I do thank you for your help.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/992496

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice