ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What to do with Error message: cannot shift object off sheet (https://www.excelbanter.com/excel-discussion-misc-queries/40318-what-do-error-message-cannot-shift-object-off-sheet.html)

arcticale

What to do with Error message: cannot shift object off sheet
 
My excel spreahseet has an outline so that it shows or hides certail level
of details by clicking the symbols 1, 2, or 3 located at the upper left hand
side of the worksheet. I am not sure what I did so that whenever I click the
symbols e.g. 1 or 2, i get an error message "cannot shift object off sheet" .
How do I correct this error?

Thanks.

Norman Jones

Hi Articale,

See MSKB article # 211769:
"Cannot shift objects off sheet" error message when you hide columns in
Excel

http://support.microsoft.com/default...b;en-ca;211769


---
Regards,
Norman



"arcticale" wrote in message
...
My excel spreahseet has an outline so that it shows or hides certail
level
of details by clicking the symbols 1, 2, or 3 located at the upper left
hand
side of the worksheet. I am not sure what I did so that whenever I click
the
symbols e.g. 1 or 2, i get an error message "cannot shift object off
sheet" .
How do I correct this error?

Thanks.




arcticale

Thanks Norman. The error is gone.

"Norman Jones" wrote:

Hi Articale,

See MSKB article # 211769:
"Cannot shift objects off sheet" error message when you hide columns in
Excel

http://support.microsoft.com/default...b;en-ca;211769


---
Regards,
Norman



"arcticale" wrote in message
...
My excel spreahseet has an outline so that it shows or hides certail
level
of details by clicking the symbols 1, 2, or 3 located at the upper left
hand
side of the worksheet. I am not sure what I did so that whenever I click
the
symbols e.g. 1 or 2, i get an error message "cannot shift object off
sheet" .
How do I correct this error?

Thanks.






All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com