If you’ve ever received an error that claims Cannot shift objects off sheet, you should keep reading. The problem occurs when your worksheet contains several objects, such as comments, charts or AutoShapes. When you try to hide or insert columns that might “push” these objects off your spreadsheet, Excel gives you an error.
Many Excel users solve this problem by simply deleting comments from the spreadsheet. But what if you need those comments?
Instead, you can simply “move” your comments out of the way by following these three steps:
Now you’ve essentially moved all of the comment objects out of the way so you can work in the spreadsheet without “pushing” them out of the worksheet. And the physical location doesn’t affect the comments’ placement when you hover your cursor over the cell. The comment still displays directly beside the cell, even though you’d moved the comment box up and to the left.