New Horizons Get Schooled Blog

Work around a common error — and keep your comments!

Excel EditsWork around a common error — and keep your comments! (Excel 2000/2002/2003/2007)

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.

Check out our Excel classes!

Posted on 1/6/11 10:00 AM by Get Schooled in Excel, in Microsoft, in New Horizons Computer Learning Center, in Spreadsheet comments, in Tips & Tricks

Get Schooled

Written by Get Schooled

Search by Topic

    Lists by Topic

    see all

    Be at the center of it all.

    SUBSCRIBE TO NEWSLETTER

    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.