Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding rows | New Users to Excel | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |