PC Review


Reply
Thread Tools Rate Thread

How to change shapes for Cell Comments

 
 
Jan T.
Guest
Posts: n/a
 
      15th Dec 2008
In Excel 2000 you can insert a comment in a Cell, mark the Comment border
and then chose from your Draw menu/Change AutoShape/Basic Shapes.
Then the Comment change from a square to any shape you chose.

Is this also possible to do with Excel 2007?

Any help is very much appreaciated.

Regards
Jan


 
Reply With Quote
 
 
 
 
Rick Rothstein
Guest
Posts: n/a
 
      15th Dec 2008
I don't do too much with XL2007, so I don't know if this is the best way or
not, but it does work. Click the down arrow on the QAT and select "More
Commands" from the popup menu that appears. Select...

"Drawing Tools | Format Tab"

from the drop down on the top, left side of the right-hand panel, then
select "Edit Shape" from the listing under that drop down, then click the
Add button. That will put a new icon on the QAT. Select your comment border,
then click this new icon and hover over the "Change Shape" item until a
fly-out panel appears with the shapes you can pick to change the Comment's
border to... pick the shape you want.

--
Rick (MVP - Excel)


"Jan T." <(E-Mail Removed)> wrote in message
news:ufHW$(E-Mail Removed)...
> In Excel 2000 you can insert a comment in a Cell, mark the Comment border
> and then chose from your Draw menu/Change AutoShape/Basic Shapes.
> Then the Comment change from a square to any shape you chose.
>
> Is this also possible to do with Excel 2007?
>
> Any help is very much appreaciated.
>
> Regards
> Jan
>


 
Reply With Quote
 
Chris Premo
Guest
Posts: n/a
 
      15th Dec 2008
Found this on the WEB:

Changing shape of comment box
Go to the office button (Top Left corner of Excel) and click the Excel
options button.

Click on the Customize option.

Change the "Choose commands from:" select to the "all commands" option.

Select the "Edit Shape" title, click the "Add" button to add this
function to the "Quick Access Toolbar", and then click the OK button.

Select the cell with the attached comment and press Shift + F2 to edit
the comment.

Click the comment's border to select the shape.

Click on quick access button "Edit Shape" command button on the "Quick
Access Toolbar".

Choose the shape desired.

Job done ;o)



--

 
Reply With Quote
 
Jan T.
Guest
Posts: n/a
 
      15th Dec 2008

Thank you so much, both of you!!

That really did the trick.

Regards
Jan


"Chris Premo" <(E-Mail Removed)> skrev i melding
news:utx8$(E-Mail Removed)...
> Found this on the WEB:
>
> Changing shape of comment box
> Go to the office button (Top Left corner of Excel) and click the Excel
> options button.
>
> Click on the Customize option.
>
> Change the "Choose commands from:" select to the "all commands" option.
>
> Select the "Edit Shape" title, click the "Add" button to add this
> function to the "Quick Access Toolbar", and then click the OK button.
>
> Select the cell with the attached comment and press Shift + F2 to edit
> the comment.
>
> Click the comment's border to select the shape.
>
> Click on quick access button "Edit Shape" command button on the "Quick
> Access Toolbar".
>
> Choose the shape desired.
>
> Job done ;o)
>
>
>
> --
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Power Point Shapes and Comments Mike Microsoft Powerpoint 1 30th Aug 2009 06:51 AM
Shapes beneath cell text? tskogstrom Microsoft Excel Misc 2 4th Oct 2007 08:57 AM
Automatically change cell comments =?Utf-8?B?TWFyY3VzIEI=?= Microsoft Excel Programming 2 28th Mar 2007 05:02 PM
How can I change two selected shapes to each other ? nanica Microsoft Powerpoint 1 28th Jul 2004 07:08 PM
change shapes during slideshow Tom Bunzel Microsoft Powerpoint 2 20th Feb 2004 04:06 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:58 AM.