oh boy...

I got a "cannot shift objects off sheet" error message on a worksheet I'm
editing. Never saw this before. Tried to search for answer using "Help" -
using the phrase (with quotes): "cannot shift objects off sheet"

I got No responses to my query AT ALL. Really! Try it yourself (using Excel
2003). The MS response was "No results found on Office Online".

Don't you think their search algorithm stinks?
Am I alone thinking this?
I really (REALLY!) dislike their search function.

I managed to access the URL:
http://support.microsoft.com/default...b;en-us;211769

- this explained the error message, sorta, but it's about getting this error
message when you try to hide columns not re-size them (is that relevant?).

BUT... (this is the FUN part!)

1) There are no shapes or comments (objects) on this worksheet that I can find

2) Column C which was hidden, resized ('cause I thot it were an Object) will
not allow itself to be hidden again, and I get that error message when I try
to hide it, AND

3) the info on the above mentioned URL says I should:

(use the) "Format menu, click <object name, where <object name is the name
of the object, such as "Comment" or "AutoShape". In the Format dialog box,
click the Properties tab.
Click Move and size with cells, and then click OK.
If you want to hide the cell comment again, right-click the cell, and then
click Hide Comment.

Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
there some OTHER Format menu they're talking 'bout? This is getting to me...

I will gladly email you a copy of this worksheet iif it helps you analyze it.

Please take pity on a confused old man and help me... Thanks.

Mark Diaz
Boston, MA


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

With Excel 2002 I've been able to fix this by deleting all rows &
columns beyond my data. It appears that Excel thinks there's something
out there & when you try to insert a row or col, it pushed the
siomething beyond the sheet limits.

Try that, see if it helps.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528587

Sorry for the post - just saw a whole set of other replies to a prev. post. I
"unmerged" all cells in the worksheet,a nd now I can re-size columns. That
must have been it.

TOO BAD microsoft doesn't tell you this!!!

WHy is their "Help" so wimpy and annoying????

"Brainless_in_Boston" wrote:

oh boy...

I got a "cannot shift objects off sheet" error message on a worksheet I'm
editing. Never saw this before. Tried to search for answer using "Help" -
using the phrase (with quotes): "cannot shift objects off sheet"

I got No responses to my query AT ALL. Really! Try it yourself (using Excel
2003). The MS response was "No results found on Office Online".

Don't you think their search algorithm stinks?
Am I alone thinking this?
I really (REALLY!) dislike their search function.

I managed to access the URL:
http://support.microsoft.com/default...b;en-us;211769

- this explained the error message, sorta, but it's about getting this error
message when you try to hide columns not re-size them (is that relevant?).

BUT... (this is the FUN part!)

1) There are no shapes or comments (objects) on this worksheet that I can find

2) Column C which was hidden, resized ('cause I thot it were an Object) will
not allow itself to be hidden again, and I get that error message when I try
to hide it, AND

3) the info on the above mentioned URL says I should:

(use the) "Format menu, click <object name, where <object name is the name
of the object, such as "Comment" or "AutoShape". In the Format dialog box,
click the Properties tab.
Click Move and size with cells, and then click OK.
If you want to hide the cell comment again, right-click the cell, and then
click Hide Comment.

Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
there some OTHER Format menu they're talking 'bout? This is getting to me...

I will gladly email you a copy of this worksheet iif it helps you analyze it.

Please take pity on a confused old man and help me... Thanks.

Mark Diaz
Boston, MA


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hi

You need to reset Excel's perception of your last used cell. Have a look
he
http://www.contextures.com/xlfaqApp.html#Unused

Hope this helps.
Andy.

"Brainless_in_Boston" wrote in
message ...
oh boy...

I got a "cannot shift objects off sheet" error message on a worksheet I'm
editing. Never saw this before. Tried to search for answer using "Help" -
using the phrase (with quotes): "cannot shift objects off sheet"

I got No responses to my query AT ALL. Really! Try it yourself (using
Excel
2003). The MS response was "No results found on Office Online".

Don't you think their search algorithm stinks?
Am I alone thinking this?
I really (REALLY!) dislike their search function.

I managed to access the URL:
http://support.microsoft.com/default...b;en-us;211769

- this explained the error message, sorta, but it's about getting this
error
message when you try to hide columns not re-size them (is that relevant?).

BUT... (this is the FUN part!)

1) There are no shapes or comments (objects) on this worksheet that I can
find

2) Column C which was hidden, resized ('cause I thot it were an Object)
will
not allow itself to be hidden again, and I get that error message when I
try
to hide it, AND

3) the info on the above mentioned URL says I should:

(use the) "Format menu, click <object name, where <object name is the
name
of the object, such as "Comment" or "AutoShape". In the Format dialog box,
click the Properties tab.
Click Move and size with cells, and then click OK.
If you want to hide the cell comment again, right-click the cell, and then
click Hide Comment.

Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
there some OTHER Format menu they're talking 'bout? This is getting to
me...

I will gladly email you a copy of this worksheet iif it helps you analyze
it.

Please take pity on a confused old man and help me... Thanks.

Mark Diaz
Boston, MA


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

tried to post this comment/update BEFORE, but... apparently MS is
brainless-proof.

Right after I posted this, I managed to find it.... and saw the other OP and
replies immed below.

Why doesn't MS TELL you that MERGED cells can cause this error message?

I READ IT HERE, not in ANY MS "Help" I found so far... annoying, eh?

"Brainless_in_Boston" wrote:

oh boy...

I got a "cannot shift objects off sheet" error message on a worksheet I'm
editing. Never saw this before. Tried to search for answer using "Help" -
using the phrase (with quotes): "cannot shift objects off sheet"

I got No responses to my query AT ALL. Really! Try it yourself (using Excel
2003). The MS response was "No results found on Office Online".

Don't you think their search algorithm stinks?
Am I alone thinking this?
I really (REALLY!) dislike their search function.

I managed to access the URL:
http://support.microsoft.com/default...b;en-us;211769

- this explained the error message, sorta, but it's about getting this error
message when you try to hide columns not re-size them (is that relevant?).

BUT... (this is the FUN part!)

1) There are no shapes or comments (objects) on this worksheet that I can find

2) Column C which was hidden, resized ('cause I thot it were an Object) will
not allow itself to be hidden again, and I get that error message when I try
to hide it, AND

3) the info on the above mentioned URL says I should:

(use the) "Format menu, click <object name, where <object name is the name
of the object, such as "Comment" or "AutoShape". In the Format dialog box,
click the Properties tab.
Click Move and size with cells, and then click OK.
If you want to hide the cell comment again, right-click the cell, and then
click Hide Comment.

Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
there some OTHER Format menu they're talking 'bout? This is getting to me...

I will gladly email you a copy of this worksheet iif it helps you analyze it.

Please take pity on a confused old man and help me... Thanks.

Mark Diaz
Boston, MA


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

TAL Kingston Ontario Canada
Finally fixed, thanks to everyone.
Top left hand corner, just left of column A, and just above line 1 is a
GLOBAL button, which when clicked on, activates the entire sheet.
You can then unmerge entire sheet, as well as delete all comments.

"Brainless_in_Boston" wrote:

tried to post this comment/update BEFORE, but... apparently MS is
brainless-proof.

Right after I posted this, I managed to find it.... and saw the other OP and
replies immed below.

Why doesn't MS TELL you that MERGED cells can cause this error message?

I READ IT HERE, not in ANY MS "Help" I found so far... annoying, eh?

"Brainless_in_Boston" wrote:

oh boy...

I got a "cannot shift objects off sheet" error message on a worksheet I'm
editing. Never saw this before. Tried to search for answer using "Help" -
using the phrase (with quotes): "cannot shift objects off sheet"

I got No responses to my query AT ALL. Really! Try it yourself (using Excel
2003). The MS response was "No results found on Office Online".

Don't you think their search algorithm stinks?
Am I alone thinking this?
I really (REALLY!) dislike their search function.

I managed to access the URL:
http://support.microsoft.com/default...b;en-us;211769

- this explained the error message, sorta, but it's about getting this error
message when you try to hide columns not re-size them (is that relevant?).

BUT... (this is the FUN part!)

1) There are no shapes or comments (objects) on this worksheet that I can find

2) Column C which was hidden, resized ('cause I thot it were an Object) will
not allow itself to be hidden again, and I get that error message when I try
to hide it, AND

3) the info on the above mentioned URL says I should:

(use the) "Format menu, click <object name, where <object name is the name
of the object, such as "Comment" or "AutoShape". In the Format dialog box,
click the Properties tab.
Click Move and size with cells, and then click OK.
If you want to hide the cell comment again, right-click the cell, and then
click Hide Comment.

Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
there some OTHER Format menu they're talking 'bout? This is getting to me...

I will gladly email you a copy of this worksheet iif it helps you analyze it.

Please take pity on a confused old man and help me... Thanks.

Mark Diaz
Boston, MA


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

This problem was really getting to me but this article sorts it all out

http://office.microsoft.com/en-us/ex...412411033.aspx

As a quick fix, try CTRL+6

Cheers Jesper