Saturday, March 17th, 2007

Any shape Excel Comments

I like to use comments in my Excel worksheets but sometimes the square yellow boxes just don’t do it for me.

Luckily with a little bit of imagination and skill, I can change the shape of my comment boxes.

Here’s how to do it yourself:

Add a comment to your worksheet and click the cell that contains the comment, right-click and choose Edit Comment and then click on the border of the comment so you have it selected.

Now, from the Drawing toolbar click the Draw button and choose the Change AutoShape option in the menu. You can select from all sorts of shapes including stars and banners and flowchart symbols.

When you’re done just click outside the comment and the change will be created for you. Neat stuff? I think so.

Helen Bradley

Thursday, March 1st, 2007

Set the style of Publisher objects

When you repeatedly use a Publisher shape or text box and when you always need to make changes to its format to meet your needs, set the shape so it always looks how you want it to look.

To do this, insert the shape or the text box for which you want to configure the defaults and right click it and choose Format AutoShape or Format Text Box as desired and make your changes. Switch to the Colors and Lines tab and enable the “Apply settings to new AutoShapes” (or “Apply settings to new Text Boxes) checkbox and click Ok. New objects of this type will now take on the selected formatting options.

Helen Bradley

Friday, February 16th, 2007

Shameless Self Promotion

Ok, so it’s not exactly a tip of the day, but I already did today’s so I feel it’s justified.

I have lots of cool Photoshop tutorials around my site, check these out:

Photoshop Brushes tutorial
Learn how to create your own Photoshop Brushes

How to use Adjustment Layers
Make photoediting a simple and undoable process using Adjustment layers

Photoshop Gradients
Fix images and create colorful effects using Photoshop Gradients

Straighten an image in Photoshop, Elements and Paintshop Pro
Straighten your images with this simple to follow tutorial that covers the popular photoediting programs

Photoshop Shapes -New!
Helen Bradley explains how to use Photoshop Shapes to edit your photos and create fun shape overlays.

Create and use Photoshop Masks
Masks aren’t as hard as you think they are and this tutorial makes them simple to use.

Create seamless patterns in Photoshop
Whether you need them for the web or for a background for an Excel worksheet, here’s how to create great seamless patterns and we’ve included a mini tutorial on TV scan lines.

Color match photos in Photoshop
Even if your photos were taken in totally different lighting

Color Swatches in Photoshop
Create your own custom color swatches and use them in your photo editing work.

Ok, so that’s done, now back to the tips..

Helen Bradley

Page 2 of 212