Cannot shift objects off sheet

  • Thread starter Thread starter MIckey Kieffer
  • Start date Start date
M

MIckey Kieffer

When I hide columns I get this error. It doesn't matter
how may columns I hide. If I hide all but any 7, they
hide.
 
The following MSKB article may help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?id=211769

Also, Dave Peterson posted this advice:
'================
Someone with the same problem posted back that their comments were
getting resized causing the trouble.

Maybe enabling: Tools|Options|View|Comment and indicator
(at least for a little bit will help.)
'========================

Or, perhaps William's suggestion in the following posting will help:

http://groups.google.com/groups?hl=en&selm=#SyiwlGICHA.2580@tkmsftngp09

He advised the following:
'=======================
"if you have a button on your worksheet, right click on the button,
select "Format Control", select "Properties" and then select "Move and
Size with cells"
'========================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping columns - error message 2
Cannot shift objects off sheet 2
I CANNOT HIDE COLUM & I GOT ERROR MASSAGE "CANNOT SHIFT PBJECTS O. 1
hide collumn function is giving error message 1
Cannot hide columns in Excel 1
Using hide in excel get "cannot shift objects off sheet" 1
Shifting objects off sheet 2
Why do I get an error message hiding excel columns 2

Back
Top