If you’re keen to add some snaz to your Cell Comments then read on!
Cell Comments are just Shapes underneath and you can treat them that way!
Ensure you have the Drawing Toolbar visible. From Excel’s menu: View > Toolbars > tick Drawing.
Add a comment to a cell.
While editing the comment, you’ll notice there is a thick striped border around the shape. While you’re typing comment text, you’ve actually got the Textbox selected, not the Shape itself. So you need to select the Shape.
Click the border or simply hit the Tab key. Notice how the thick striped border changes to a dotted pattern.
Now that you’ve got the Shape selected, you can change many properties of the appearance.
eg. From the Drawing toolbar: Draw > Change Autoshape > Stars and Banners > 16 point Star.
Everything you need to alter the appearance of the comment is available from the Drawing toolbar – Shadows, 3D, Colour, etc…
thanks,
fantastic.
before this I knew only how to embed pictures in comments.
thanks again,
cheers.
Can’t seem to get this to work in Excel XP. Is this feature unique to 2003 version? … though it is not entirely inconceivable that I’m just flubbing the directions.
It works under Excel XP.
I was not able to make the shape 3D though – perhaps 3D is 2003 only?
3d works, for me, in xl2k.
Nice,
works for me even in xl97 sr-2.
Joop
Thanks Andy
On second try I discovered some shapes allow 3D, some don’t.
What’s next ? Blinking cells ? ;-)
Its also documented on Debra Dalgleish’s site
for reference:
http://www.contextures.com/xlcomments02.html#Shape
Regards,
Tom Ogilvy
This is COOL
I love pleasant tips like these….
Excel never ceases to amaze. . . neither does the daily dose. . .
Keep up the good work!