Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Error message: "cannot shift object off sheet"

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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,173
Default 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"


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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 -


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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 -



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"cannot shift objects off sheet" REAL help needed Brainless_in_Boston Excel Discussion (Misc queries) 6 August 19th 08 10:31 AM
"cannot shift object off sheet". Ah Ong Excel Discussion (Misc queries) 1 September 18th 06 08:40 AM
when hiding columns mess: "cannot shift objects off sheet" KM Excel Discussion (Misc queries) 1 August 4th 06 02:01 AM
Why I am getting Error Message: "Cannot shift objects off sheet"?? GreenInIowa Excel Worksheet Functions 0 March 23rd 06 07:05 PM
I get an error message that says "Cannot shift object off a page" JZygmun Excel Discussion (Misc queries) 1 March 7th 06 03:18 AM


All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"