Excel 2003 - Curious New Features

[PT]

I've noticed several things which I'd like to be able to understand, control
and/or eliminate:

1. On come cells, there's a dark triangle in the upper LH corner of the
cell accompanied by a yellow exclamation point in a diamond. The cells in
question don't appear to contain anything out of the ordinary.

When I paste a cell's contents into other cells, the right side of the
screen is taken over by a display of clipboard contents, which I didn't ask
for. In addition, a small Paste icon appears next to the cells.

Occasionally a Format painter icon appears next to a cell for no particular
reason. I don't use Format Painter, and it isn't on any of my toolbars.

Please advise

 

[kharbin]

Hi, PT.

Regarding your dark triangle, to my best recollection I
got rid of it by changing the cell's format. To do the
same, click the affected cell, then go to Format -->
Cells. Once you're in, make sure you're in the Number
tab, and select the appropriate category (General probably
won't solve the problem -- you probably want Text, Number,
Date, or whatever).

As for how to get rid of those incredibly annoying little
icons, I'm trying to find the answer myself. (Microsoft,
if you're monitoring this discussion group, I DO know how
to use the "Paste Special" command -- your clipboard
shortcut just gets in my way, blocks my view, and
irritates the heck out of me.)

Good luck!

 

[PT]

I discovered the answer to the clipboard question.

Click Edit | Office Clipboard | Options to change settings.

--
PT
Hi, PT.

Regarding your dark triangle, to my best recollection I
got rid of it by changing the cell's format. To do the
same, click the affected cell, then go to Format -->
Cells. Once you're in, make sure you're in the Number
tab, and select the appropriate category (General probably
won't solve the problem -- you probably want Text, Number,
Date, or whatever).

As for how to get rid of those incredibly annoying little
icons, I'm trying to find the answer myself. (Microsoft,
if you're monitoring this discussion group, I DO know how
to use the "Paste Special" command -- your clipboard
shortcut just gets in my way, blocks my view, and
irritates the heck out of me.)

Good luck!

 

[kharbin]

Thank you! Thank you! Thank you!

; )

-----Original Message-----
I discovered the answer to the clipboard question.

Click Edit | Office Clipboard | Options to change settings.

--
PT
Hi, PT.

Regarding your dark triangle, to my best recollection I
got rid of it by changing the cell's format. To do the
same, click the affected cell, then go to Format -->
Cells. Once you're in, make sure you're in the Number
tab, and select the appropriate category (General probably
won't solve the problem -- you probably want Text, Number,
Date, or whatever).

As for how to get rid of those incredibly annoying little
icons, I'm trying to find the answer myself. (Microsoft,
if you're monitoring this discussion group, I DO know how
to use the "Paste Special" command -- your clipboard
shortcut just gets in my way, blocks my view, and
irritates the heck out of me.)

Good luck!


.