Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default "Can't shift objects off sheet"

This message is displayed sometimes when hiding rows or columns in Excel. It
has also appeared when trying to reduce the size of a row height. This is
even after the colums or rows in question have been 'cleared". thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default "Can't shift objects off sheet"

Hi,

I have seen this when you Insert rows or columns but not when you Delete them.

In the first case, you should select the column directly after the last
column you want to retain and press Shift+Ctrl+Right Arrow. Then press
Ctrl+- (Control Minus)

Similarly for rows, select the first non useful row after you data and then
press Shift+Ctrl+Down Arrow. Then Ctrl+- as above. Save the file. See if
that helps.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"PRINCE" wrote:

This message is displayed sometimes when hiding rows or columns in Excel. It
has also appeared when trying to reduce the size of a row height. This is
even after the colums or rows in question have been 'cleared". thanks

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
Closing grouping in Excel I get "Cannot shift objects off sheet"? Nasty Merasty Excel Discussion (Misc queries) 1 February 1st 08 05:16 PM
how do I correct error "Can not shift objects offf sheet" MOnte Excel Discussion (Misc queries) 1 April 30th 07 04:57 PM
Excel error "Cannot shift objects off sheet", can I fix? LionHearted1952 Excel Discussion (Misc queries) 1 September 30th 06 05:27 PM
unable to hide columns -"can not shift objects off sheet" shows Pinaki Excel Worksheet Functions 2 August 4th 06 03:15 PM
when hiding columns mess: "cannot shift objects off sheet" KM Excel Discussion (Misc queries) 1 August 4th 06 02:01 AM


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

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

About Us

"It's about Microsoft Excel"