Error message: "cannot shift object off sheet"
 

I am trying to hide rows and get the error message "connot shift objects off
sheet"

Error message: "cannot shift object off sheet"
 

Peter

You have 'data' to the right or below where you think

Select A1 and press Ctrl+Right Arrow or Arrow down for rows. This is where
Excel thinks your data goes to.

To correct this, select the whole of the last row/column that Excel 'thinks'
it has and then, holding the shift key down, select the last entire
row/column that you 'know' you have. Now select EditDelete and save the
workbook.

That should fix it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Peter Vickers" <Peter wrote in message
...
I am trying to hide rows and get the error message "connot shift objects
off
sheet"

Error message: "cannot shift object off sheet"
 

another option is that he has comments somewhere on the worksheet,
removing comments usually solves that error (and is the first source to
look for when you get it)

On Dec 8, 6:56 am, "Nick Hodge"
wrote:
Peter

You have 'data' to the right or below where you think

Select A1 and press Ctrl+Right Arrow or Arrow down for rows. This is where
Excel thinks your data goes to.

To correct this, select the whole of the last row/column that Excel 'thinks'
it has and then, holding the shift key down, select the last entire
row/column that you 'know' you have. Now select EditDelete and save the
workbook.

That should fix it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
e.co.uk

"Peter Vickers" <Peter wrote in ...



I am trying to hide rows and get the error message "connot shift objects
off
sheet"- Hide quoted text -- Show quoted text -

Error message: "cannot shift object off sheet"
 

Hi

Thanks for your help. I will give it a try.

kind regards

Peter Vickers

"Adrien Rochereau" wrote:

another option is that he has comments somewhere on the worksheet,
removing comments usually solves that error (and is the first source to
look for when you get it)

On Dec 8, 6:56 am, "Nick Hodge"
wrote:
Peter

You have 'data' to the right or below where you think

Select A1 and press Ctrl+Right Arrow or Arrow down for rows. This is where
Excel thinks your data goes to.

To correct this, select the whole of the last row/column that Excel 'thinks'
it has and then, holding the shift key down, select the last entire
row/column that you 'know' you have. Now select EditDelete and save the
workbook.

That should fix it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
e.co.uk

"Peter Vickers" <Peter wrote in ...



I am trying to hide rows and get the error message "connot shift objects
off
sheet"- Hide quoted text -- Show quoted text -

Error message: "cannot shift object off sheet"
 

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

Peter Vickers wrote:

I am trying to hide rows and get the error message "connot shift objects off
sheet"

--

Dave Peterson