Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default How to change shapes for Cell Comments

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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default How to change shapes for Cell Comments

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." wrote in message
...
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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default How to change shapes for Cell Comments

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)



--

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default How to change shapes for Cell Comments


Thank you so much, both of you!!

That really did the trick. :)

Regards
Jan


"Chris Premo" skrev i melding
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i change the size of multiple shapes at the same time? Amber Excel Discussion (Misc queries) 0 September 25th 08 09:14 PM
Naming Auto Shapes and Creating new Shapes AL2000 Excel Discussion (Misc queries) 3 September 10th 07 04:12 AM
When drawing shapes in excel the shapes keep disappearing Tape Excel Discussion (Misc queries) 1 October 6th 06 04:23 PM
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM


All times are GMT +1. The time now is 08:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"