Hiding Columns In Excel

  • Thread starter Thread starter Tom Hamilton
  • Start date Start date
T

Tom Hamilton

When I try to hide too many columns in Excell I get the
following message and it won't let me hide the
columns, "Cannot Shift Objects off Sheet.".

Is there a workaround? What am I doing wrong?
 
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 recently 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"
'========================
 
Back
Top