ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem in hiding columns (https://www.excelbanter.com/excel-discussion-misc-queries/200644-problem-hiding-columns.html)

Hardik Shah

Problem in hiding columns
 
Friends,

While i am trying to hide the columns in excel worksheet, i am getting the
pop up message "Cannot shift objects off sheet" due to which i can't hide the
columns.

So, please help to come out of this problem.

Regards,

Hardik

Gord Dibben

Problem in hiding columns
 
Have a look at this KB Article.

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

Watch out for Comments which are hidden and could possibly have their flags
disabled in ToolsOptionsViewCommentsNone


Gord Dibben MS Excel MVP

On Thu, 28 Aug 2008 16:14:01 -0700, Hardik Shah
wrote:

Friends,

While i am trying to hide the columns in excel worksheet, i am getting the
pop up message "Cannot shift objects off sheet" due to which i can't hide the
columns.

So, please help to come out of this problem.

Regards,

Hardik



Dave Peterson

Problem in hiding columns
 
Maybe...

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.

Hardik Shah wrote:

Friends,

While i am trying to hide the columns in excel worksheet, i am getting the
pop up message "Cannot shift objects off sheet" due to which i can't hide the
columns.

So, please help to come out of this problem.

Regards,

Hardik


--

Dave Peterson


All times are GMT +1. The time now is 07:09 PM.

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