LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default "cannot shift objects off sheet" error

(Excel 2002, 10.2614.2625)
Spreadsheet has ~100x150 (rowsxcols). It uses conditional formatting to
color columns by whether they have a cell that matches that in the same
row of a 'filter' column. To visualize patterns over the whole sheet, I
reduce the column width to 1 (or less). This leaves the content not
readable, but the column colors are visible.

This used to work fine. Recently, when I try to reduce the width, I get
the message "cannot shift objects off sheet".

If I delete all comments, I do not get this error.

If I reduce the number of columns to less than ~80, the error goes away.
However, it doesn't seem to matter _which_ columns I delete - either
left or right, it seems to just be a matter of how many columns are
present.

Eliminating rows does not seem to help, unless I delete almost
everything.

This is not a huge issue; but, I would appreciate it if anyone could
shed some light on what's going on.

Thanks,
G
 
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
Define error "Can't shift objects off sheet" oilsands Excel Discussion (Misc queries) 2 July 11th 07 09:21 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
Why I am getting Error Message: "Cannot shift objects off sheet"?? GreenInIowa Excel Worksheet Functions 0 March 23rd 06 06:05 PM
Error Message: "Cannot shift objects off sheet." AndrewS Excel Discussion (Misc queries) 1 January 11th 06 04:09 PM


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