You might want to take a look at this KB article

http://support.microsoft.com?kbid=170081
XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns

--
HTH

Bob Phillips

"srinivasan" wrote in message
...
I have a work sheet moderately big with multiple columns and rows. When I
want to hide the rows and columns beyond data area for the purpose of easy
scrolling I got a message " cannot shift objects beyond sheet". I dont
know
why? Any suggestions to hide rows and columns will help me a lot.
Thanks a lot.