Difficulty hiding rows
 

I'm copying and pasting data into a worksheet. When I try and hide rows to
make the scroll bar more usable, I get the message 'cannot shift objects off
sheet'. These rows are blank. Any suggestions?
Thanks
Karen

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1

Difficulty hiding rows
 

See if this article helps

http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel

it says columns, but may equally apply to rows.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"purpletigerface via OfficeKB.com" <u31994@uwe wrote in message
news:6e60aae989e90@uwe...
I'm copying and pasting data into a worksheet. When I try and hide rows to
make the scroll bar more usable, I get the message 'cannot shift objects
off
sheet'. These rows are blank. Any suggestions?
Thanks
Karen

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1

Difficulty hiding rows
 

Thanks Bob,
That article sounds like it might help except I don't know how to find the
(hidden?) object that might be in those 62,000 rows I'm trying to hide. The
article seems to rely on you knowing where the object is!
Interestingly, when I use Ctrl + End to move to the last entry, in fact it
moves to the last row on the worksheet. I wonder if I'm pasting in some
formatting or something from the data I'm moving that is causing this? It's
come from a very old Word Perfect Version via Word!
Karen

Bob Phillips wrote:
See if this article helps

http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel

it says columns, but may equally apply to rows.

I'm copying and pasting data into a worksheet. When I try and hide rows to
make the scroll bar more usable, I get the message 'cannot shift objects
off
sheet'. These rows are blank. Any suggestions?
Thanks
Karen

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1