Article ID: 211769 - View products that this article applies to.
This article was previously published under Q211769
For a Excel 97 version of this article, see 170081
For a Excel 98 Macintosh Edition version of this article, see 178959
You try to perform one of the following operations:
To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
Cannot shift objects off sheet.
This error message occurs if the following conditions are true:
Additionally, this error message occurs when there are hidden objects on the worksheet.
Note This problem occurs with most objects that can be inserted into a worksheet. This includes but is not limited to cell comments, graphs, drawing shapes, and pictures. Pay special notice to cell comments. By default and unlike most objects, cell comments are hidden and may not be immediately visible.
Also, you may receive the error message if you try to hide the column that has the object and all the columns to the right side of the column that has the object. This depends on the location of the column that contains the object. .
To resolve this problem, follow the steps in the method that applies to your version of Excel. In Excel 2007, use Method 1. In Excel 2003, Excel 2002, and Excel 2000, use Method 2.
Method 1: Temporarily toggle the option from "Nothing (hide objects)" to AllIn Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cellsTo work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
Alternative Method: Change the property on all the objects on the active worksheetMicrosoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure. However, they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
Note Running the following macro sets the property that is mentioned in Method 1 for all the objects on the active worksheet. Because this setting causes objects to resize when the rows and the columns that are associated with the object are resized, it can cause unexpected results when it displays the objects on the worksheet if you resize the rows and the columns. Consider this problem before you run the macro in your file.
To change the property on all the comments on the active worksheet, run the following macro.
Contact us for more help
Connect with Answer Desk for expert help.