Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
(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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define error "Can't shift objects off sheet" | Excel Discussion (Misc queries) | |||
how do I correct error "Can not shift objects offf sheet" | Excel Discussion (Misc queries) | |||
Excel error "Cannot shift objects off sheet", can I fix? | Excel Discussion (Misc queries) | |||
Why I am getting Error Message: "Cannot shift objects off sheet"?? | Excel Worksheet Functions | |||
Error Message: "Cannot shift objects off sheet." | Excel Discussion (Misc queries) |