Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
AndrewS
 
Posts: n/a
Default Error Message: "Cannot shift objects off sheet."

My spreadsheet (form) uses 187 columns for data entry. I am attempting to
"hide" select columns in the spreadsheet and am able to do so up to a point.
However, after hiding approximately 30 columns, I am receiving the error
message, "Cannot shift objects off sheet."

What does this error message mean? I've requested assistance from two Excel
experts here at work and they are not able to identify the issue.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope
 
Posts: n/a
Default Error Message: "Cannot shift objects off sheet."

Hi,

Maybe this KB is of relevance.
http://support.microsoft.com/kb/q170081/

Cheers
Andy

AndrewS wrote:
My spreadsheet (form) uses 187 columns for data entry. I am attempting to
"hide" select columns in the spreadsheet and am able to do so up to a point.
However, after hiding approximately 30 columns, I am receiving the error
message, "Cannot shift objects off sheet."

What does this error message mean? I've requested assistance from two Excel
experts here at work and they are not able to identify the issue.

Thanks!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
What does the message: "Cannot shift objects off sheet" mean? CTruesdale Excel Worksheet Functions 1 December 1st 05 07:18 PM
Using hide in excel get "cannot shift objects off sheet" snowbounduk Excel Worksheet Functions 1 November 22nd 05 03:15 PM
Getting an error message "Cannot shift objects off of sheet" carey Excel Discussion (Misc queries) 11 July 3rd 05 02:13 AM
Get Msg "Cannot shift objects off sheet" when hidng columns" Why? Steve Ball Excel Discussion (Misc queries) 2 June 27th 05 06:41 PM
Help - Cannot shift objects off sheet problem sedelson@no Excel Discussion (Misc queries) 6 December 29th 04 07:34 PM


All times are GMT +1. The time now is 10:11 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"