software

oh boy...

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

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

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:
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) quot;Format menu, click lt;object namegt;, where lt;object namegt; is the name
of the object, such as quot;Commentquot; or quot;AutoShapequot;. 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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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


With Excel 2002 I've been able to fix this by deleting all rows amp;
columns beyond my data. It appears that Excel thinks there's something
out there amp; 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: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=528587Sorry for the post - just saw a whole set of other replies to a prev. post. I
quot;unmergedquot; 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 quot;Helpquot; so wimpy and annoying????

quot;Brainless_in_Bostonquot; wrote:

gt; oh boy...
gt;
gt; I got a quot;cannot shift objects off sheetquot; error message on a worksheet I'm
gt; editing. Never saw this before. Tried to search for answer using quot;Helpquot; -
gt; using the phrase (with quotes): quot;cannot shift objects off sheetquot;
gt;
gt; I got No responses to my query AT ALL. Really! Try it yourself (using Excel
gt; 2003). The MS response was quot;No results found on Office Onlinequot;.
gt;
gt; Don't you think their search algorithm stinks?
gt; Am I alone thinking this?
gt; I really (REALLY!) dislike their search function.
gt;
gt; I managed to access the URL:
gt; support.microsoft.com/default...b;en-us;211769
gt;
gt; - this explained the error message, sorta, but it's about getting this error
gt; message when you try to hide columns not re-size them (is that relevant?).
gt;
gt; BUT... (this is the FUN part!)
gt;
gt; 1) There are no shapes or comments (objects) on this worksheet that I can find
gt;
gt; 2) Column C which was hidden, resized ('cause I thot it were an Object) will
gt; not allow itself to be hidden again, and I get that error message when I try
gt; to hide it, AND
gt;
gt; 3) the info on the above mentioned URL says I should:
gt;
gt; (use the) quot;Format menu, click lt;object namegt;, where lt;object namegt; is the name
gt; of the object, such as quot;Commentquot; or quot;AutoShapequot;. In the Format dialog box,
gt; click the Properties tab.
gt; Click Move and size with cells, and then click OK.
gt; If you want to hide the cell comment again, right-click the cell, and then
gt; click Hide Comment.
gt;
gt; Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
gt; Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
gt; there some OTHER Format menu they're talking 'bout? This is getting to me...
gt;
gt; I will gladly email you a copy of this worksheet iif it helps you analyze it.
gt;
gt; Please take pity on a confused old man and help me... Thanks.
gt;
gt; Mark Diaz
gt; Boston, MA
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; 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
www.contextures.com/xlfaqApp.html#Unused

Hope this helps.
Andy.

quot;Brainless_in_Bostonquot; gt; wrote in
message ...
gt; oh boy...
gt;
gt; I got a quot;cannot shift objects off sheetquot; error message on a worksheet I'm
gt; editing. Never saw this before. Tried to search for answer using quot;Helpquot; -
gt; using the phrase (with quotes): quot;cannot shift objects off sheetquot;
gt;
gt; I got No responses to my query AT ALL. Really! Try it yourself (using
gt; Excel
gt; 2003). The MS response was quot;No results found on Office Onlinequot;.
gt;
gt; Don't you think their search algorithm stinks?
gt; Am I alone thinking this?
gt; I really (REALLY!) dislike their search function.
gt;
gt; I managed to access the URL:
gt; support.microsoft.com/default...b;en-us;211769
gt;
gt; - this explained the error message, sorta, but it's about getting this
gt; error
gt; message when you try to hide columns not re-size them (is that relevant?).
gt;
gt; BUT... (this is the FUN part!)
gt;
gt; 1) There are no shapes or comments (objects) on this worksheet that I can
gt; find
gt;
gt; 2) Column C which was hidden, resized ('cause I thot it were an Object)
gt; will
gt; not allow itself to be hidden again, and I get that error message when I
gt; try
gt; to hide it, AND
gt;
gt; 3) the info on the above mentioned URL says I should:
gt;
gt; (use the) quot;Format menu, click lt;object namegt;, where lt;object namegt; is the
gt; name
gt; of the object, such as quot;Commentquot; or quot;AutoShapequot;. In the Format dialog box,
gt; click the Properties tab.
gt; Click Move and size with cells, and then click OK.
gt; If you want to hide the cell comment again, right-click the cell, and then
gt; click Hide Comment.
gt;
gt; Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
gt; Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
gt; there some OTHER Format menu they're talking 'bout? This is getting to
gt; me...
gt;
gt; I will gladly email you a copy of this worksheet iif it helps you analyze
gt; it.
gt;
gt; Please take pity on a confused old man and help me... Thanks.
gt;
gt; Mark Diaz
gt; Boston, MA
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; 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 quot;Helpquot; I found so far... annoying, eh?

quot;Brainless_in_Bostonquot; wrote:

gt; oh boy...
gt;
gt; I got a quot;cannot shift objects off sheetquot; error message on a worksheet I'm
gt; editing. Never saw this before. Tried to search for answer using quot;Helpquot; -
gt; using the phrase (with quotes): quot;cannot shift objects off sheetquot;
gt;
gt; I got No responses to my query AT ALL. Really! Try it yourself (using Excel
gt; 2003). The MS response was quot;No results found on Office Onlinequot;.
gt;
gt; Don't you think their search algorithm stinks?
gt; Am I alone thinking this?
gt; I really (REALLY!) dislike their search function.
gt;
gt; I managed to access the URL:
gt; support.microsoft.com/default...b;en-us;211769
gt;
gt; - this explained the error message, sorta, but it's about getting this error
gt; message when you try to hide columns not re-size them (is that relevant?).
gt;
gt; BUT... (this is the FUN part!)
gt;
gt; 1) There are no shapes or comments (objects) on this worksheet that I can find
gt;
gt; 2) Column C which was hidden, resized ('cause I thot it were an Object) will
gt; not allow itself to be hidden again, and I get that error message when I try
gt; to hide it, AND
gt;
gt; 3) the info on the above mentioned URL says I should:
gt;
gt; (use the) quot;Format menu, click lt;object namegt;, where lt;object namegt; is the name
gt; of the object, such as quot;Commentquot; or quot;AutoShapequot;. In the Format dialog box,
gt; click the Properties tab.
gt; Click Move and size with cells, and then click OK.
gt; If you want to hide the cell comment again, right-click the cell, and then
gt; click Hide Comment.
gt;
gt; Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
gt; Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
gt; there some OTHER Format menu they're talking 'bout? This is getting to me...
gt;
gt; I will gladly email you a copy of this worksheet iif it helps you analyze it.
gt;
gt; Please take pity on a confused old man and help me... Thanks.
gt;
gt; Mark Diaz
gt; Boston, MA
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; 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.
quot;Brainless_in_Bostonquot; wrote:

gt; tried to post this comment/update BEFORE, but... apparently MS is
gt; brainless-proof.
gt;
gt; Right after I posted this, I managed to find it.... and saw the other OP and
gt; replies immed below.
gt;
gt; Why doesn't MS TELL you that MERGED cells can cause this error message?
gt;
gt; I READ IT HERE, not in ANY MS quot;Helpquot; I found so far... annoying, eh?
gt;
gt; quot;Brainless_in_Bostonquot; wrote:
gt;
gt; gt; oh boy...
gt; gt;
gt; gt; I got a quot;cannot shift objects off sheetquot; error message on a worksheet I'm
gt; gt; editing. Never saw this before. Tried to search for answer using quot;Helpquot; -
gt; gt; using the phrase (with quotes): quot;cannot shift objects off sheetquot;
gt; gt;
gt; gt; I got No responses to my query AT ALL. Really! Try it yourself (using Excel
gt; gt; 2003). The MS response was quot;No results found on Office Onlinequot;.
gt; gt;
gt; gt; Don't you think their search algorithm stinks?
gt; gt; Am I alone thinking this?
gt; gt; I really (REALLY!) dislike their search function.
gt; gt;
gt; gt; I managed to access the URL:
gt; gt; support.microsoft.com/default...b;en-us;211769
gt; gt;
gt; gt; - this explained the error message, sorta, but it's about getting this error
gt; gt; message when you try to hide columns not re-size them (is that relevant?).
gt; gt;
gt; gt; BUT... (this is the FUN part!)
gt; gt;
gt; gt; 1) There are no shapes or comments (objects) on this worksheet that I can find
gt; gt;
gt; gt; 2) Column C which was hidden, resized ('cause I thot it were an Object) will
gt; gt; not allow itself to be hidden again, and I get that error message when I try
gt; gt; to hide it, AND
gt; gt;
gt; gt; 3) the info on the above mentioned URL says I should:
gt; gt;
gt; gt; (use the) quot;Format menu, click lt;object namegt;, where lt;object namegt; is the name
gt; gt; of the object, such as quot;Commentquot; or quot;AutoShapequot;. In the Format dialog box,
gt; gt; click the Properties tab.
gt; gt; Click Move and size with cells, and then click OK.
gt; gt; If you want to hide the cell comment again, right-click the cell, and then
gt; gt; click Hide Comment.
gt; gt;
gt; gt; Wonderful! Yeah, but... my Format menu (Excel 2003) only has: Cells, Rows,
gt; gt; Column, Sheet, AutoFormat, Conditional Formatting and Style as options. Is
gt; gt; there some OTHER Format menu they're talking 'bout? This is getting to me...
gt; gt;
gt; gt; I will gladly email you a copy of this worksheet iif it helps you analyze it.
gt; gt;
gt; gt; Please take pity on a confused old man and help me... Thanks.
gt; gt;
gt; gt; Mark Diaz
gt; gt; Boston, MA
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...lic.excel.misc

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

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

As a quick fix, try CTRL 6

Cheers Jesper