EXCEL ERROR MESSAGE
When I try to hide certain columns on one of my excel worksheets I get the
error message, "cannot move objects off sheet". As far as I know the only thing in my columns are text and some simple formulas. How do I fix this so I can hide columns I don't want to see? My sheet is not protected, neither are any cells on my sheet. |
EXCEL ERROR MESSAGE
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. kadmin wrote: When I try to hide certain columns on one of my excel worksheets I get the error message, "cannot move objects off sheet". As far as I know the only thing in my columns are text and some simple formulas. How do I fix this so I can hide columns I don't want to see? My sheet is not protected, neither are any cells on my sheet. -- Dave Peterson |
EXCEL ERROR MESSAGE
Thanks, but I have no comments and merged cells don't seem to be the issue.
I have merged cells every three columns across the entire worsheet and most of them I can hide. A few of the columns for some reason I cannot hide. Do you have any other suggestions? "Dave Peterson" wrote: XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. kadmin wrote: When I try to hide certain columns on one of my excel worksheets I get the error message, "cannot move objects off sheet". As far as I know the only thing in my columns are text and some simple formulas. How do I fix this so I can hide columns I don't want to see? My sheet is not protected, neither are any cells on my sheet. -- Dave Peterson |
EXCEL ERROR MESSAGE
Just what was in that KB article.
kadmin wrote: Thanks, but I have no comments and merged cells don't seem to be the issue. I have merged cells every three columns across the entire worsheet and most of them I can hide. A few of the columns for some reason I cannot hide. Do you have any other suggestions? "Dave Peterson" wrote: XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. kadmin wrote: When I try to hide certain columns on one of my excel worksheets I get the error message, "cannot move objects off sheet". As far as I know the only thing in my columns are text and some simple formulas. How do I fix this so I can hide columns I don't want to see? My sheet is not protected, neither are any cells on my sheet. -- Dave Peterson -- Dave Peterson |
EXCEL ERROR MESSAGE
I deleted all the comments on the worksheet and now I can hide the columns I
need to. Thanks. "kadmin" wrote: Thanks, but I have no comments and merged cells don't seem to be the issue. I have merged cells every three columns across the entire worsheet and most of them I can hide. A few of the columns for some reason I cannot hide. Do you have any other suggestions? "Dave Peterson" wrote: XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. kadmin wrote: When I try to hide certain columns on one of my excel worksheets I get the error message, "cannot move objects off sheet". As far as I know the only thing in my columns are text and some simple formulas. How do I fix this so I can hide columns I don't want to see? My sheet is not protected, neither are any cells on my sheet. -- Dave Peterson |
All times are GMT +1. The time now is 07:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com