I have a spreadsheet that is setup columns A-IV and need to hide columns but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig

How are you hiding the columns?

It sounds like you might be adding columns or moving cells to the right to
hide them from the view.
If you have items in Column IV you can not do this.

If you are doing it as<format<columns<hide
about howmany times do you do it before you have the problem.
(I cant make it happen on my computer)

If you are doing it another way, What is it?

"craig" wrote:

I have a spreadsheet that is setup columns A-IV and need to hide columns but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig

I highlight the cells I wish to hide by dragging the mouse across the column
headings, rightclick and choose the hide option, I have only got to cells BU
at present before I get the "cannot shift" error message

regards Craig

"bj" wrote in message
...
How are you hiding the columns?

It sounds like you might be adding columns or moving cells to the right to
hide them from the view.
If you have items in Column IV you can not do this.

If you are doing it as<format<columns<hide
about howmany times do you do it before you have the problem.
(I cant make it happen on my computer)

If you are doing it another way, What is it?

"craig" wrote:

I have a spreadsheet that is setup columns A-IV and need to hide columns
but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig

I still have not been able to duplicate your problem.
If you save the file at that point and reopen it, does it still not allow
you to hide more columns?

Do you have macros which do anything on action?
Is the initial set up done by a macro?

When you first start up if you <edit<goto<special "last cell" does it
goto column IV.
When you have hidden some columns ,before it locks up., does it goto the
same cell. once it wont let you hide any more will it still go to the same
cell?

As you can probably tell, I am going fishing cause I do not know what is
causing your problem.

"craig" wrote:

I highlight the cells I wish to hide by dragging the mouse across the column
headings, rightclick and choose the hide option, I have only got to cells BU
at present before I get the "cannot shift" error message

regards Craig

"bj" wrote in message
...
How are you hiding the columns?

It sounds like you might be adding columns or moving cells to the right to
hide them from the view.
If you have items in Column IV you can not do this.

If you are doing it as<format<columns<hide
about howmany times do you do it before you have the problem.
(I cant make it happen on my computer)

If you are doing it another way, What is it?

"craig" wrote:

I have a spreadsheet that is setup columns A-IV and need to hide columns
but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig

craig

Two KB articles on this subject.

http://support.microsoft.com/kb/q170081/ ......for XL97

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


Gord Dibben Excel MVP

On Mon, 09 May 2005 15:29:21 GMT, "craig" wrote:

I have a spreadsheet that is setup columns A-IV and need to hide columns but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig

Thanks Gord, running the macro has cured my problem

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
craig

Two KB articles on this subject.

http://support.microsoft.com/kb/q170081/ ......for XL97

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


Gord Dibben Excel MVP

On Mon, 09 May 2005 15:29:21 GMT, "craig"
wrote:

I have a spreadsheet that is setup columns A-IV and need to hide columns
but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig

Thanks for your time and effort I had reply from another newsgroup and its
all to do with comments in cells running the macro found at the link below
has cured the problem.

thanks again Craig

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

"bj" wrote in message
...
I still have not been able to duplicate your problem.
If you save the file at that point and reopen it, does it still not allow
you to hide more columns?

Do you have macros which do anything on action?
Is the initial set up done by a macro?

When you first start up if you <edit<goto<special "last cell" does it
goto column IV.
When you have hidden some columns ,before it locks up., does it goto the
same cell. once it wont let you hide any more will it still go to the same
cell?

As you can probably tell, I am going fishing cause I do not know what is
causing your problem.

"craig" wrote:

I highlight the cells I wish to hide by dragging the mouse across the
column
headings, rightclick and choose the hide option, I have only got to cells
BU
at present before I get the "cannot shift" error message

regards Craig

"bj" wrote in message
...
How are you hiding the columns?

It sounds like you might be adding columns or moving cells to the right
to
hide them from the view.
If you have items in Column IV you can not do this.

If you are doing it as<format<columns<hide
about howmany times do you do it before you have the problem.
(I cant make it happen on my computer)

If you are doing it another way, What is it?

"craig" wrote:

I have a spreadsheet that is setup columns A-IV and need to hide
columns
but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig

Excellent news.

Thanks for the feedback.


Gord

On Mon, 09 May 2005 20:35:01 GMT, "craig" wrote:

Thanks Gord, running the macro has cured my problem

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
craig

Two KB articles on this subject.

http://support.microsoft.com/kb/q170081/ ......for XL97

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


Gord Dibben Excel MVP

On Mon, 09 May 2005 15:29:21 GMT, "craig"
wrote:

I have a spreadsheet that is setup columns A-IV and need to hide columns
but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig