Cannot shift objects off sheet?

**SpringLily** · 11-03-2010, 05:43 AM

Dear All,
I have a spreadsheet as attached and what I would like to do is to hide all column after column Q, but Excel give an error message says: "Cannot shift objects off sheet". As far as I aware, there is no objects after column Q. Can anybody help me please? How do I if there is object in the range or not?

Thanks.
Lily

**Andy Pope** · 11-03-2010, 05:48 AM

Does the sheet have comments?

BTW, there is no attachment to your thread.

**SpringLily** · 11-03-2010, 05:57 AM

Sorry, Andy! Please see the attached.

**SpringLily** · 11-03-2010, 06:04 AM

Thanks, Andy. It was a comments. After I removed it, I can do what I want to do. Thanks. Lily.

**DavidHips** · 05-01-2013, 11:10 PM

I am experiencing the same problems but cannot find comments and I deleted all objects.

**HaHoBe** · 05-01-2013, 11:33 PM

Hi, DavidHips,

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Ciao,
Holger