Cannot shift objects off sheet

This is for Excel 2007 but may apply to older versions.

When you attempt to insert rows or hide columns you may get

"Cannot shift objects off sheet"

Changing the properties of objects such as cell comments may fix the issue. Follow these steps

Right-click a cell that has a hidden comment
Choose Show/Hide Comments
Position the cursor over one corner of the cell till you see a four-pointed arrow
Click to select the comment box
Select Format
1. This is located in the Cells group on the Home tab
Choose Format Comment
Click Properties
Click Move and Size with Cells
Click OK

Contact Email: Support@upgradenrepair.com

DISCLAIMER:UpgradeNRepair (UNR), the owner, and any representatives of UpgradeNRepair (UNR) is not liable for any data loss or hardware failure because of the following procedure. The Information provided is a guide to assist the customer with an issue with their system or software. The procedures offered here may or may not harm your files. Even procedures that are not designed to harm files, can harm files, depending on the issue with the system. Because there is too many unknowns, UpgradeNRepair is unable to guarantee the safety of the files. Customer is responsible for their data and their actions. Before following the directions on this page and the pages these links are linked to, any data the customer does not want to lose will have to be saved. Saving the data is the sole responsibility of the customer. Some or all of the following procedures or information may not apply to your situation.