Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing grouping in Excel I get "Cannot 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) | |||
unable to hide columns -"can not shift objects off sheet" shows | Excel Worksheet Functions | |||
when hiding columns mess: "cannot shift objects off sheet" | Excel Discussion (Misc queries) |