ExcelBanter - Hiding of rows and columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding of rows and columns (https://www.excelbanter.com/excel-discussion-misc-queries/36387-hiding-rows-columns.html)

Hiding of rows and columns

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.

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.