The LANcom Microsoft Office Secret is a weekly email we send out every Friday. This email contains one tip or ‘secret’ explaining how to use a feature of an Office program. These Secrets cover tips for Excel, Outlook, PowerPoint, and Word for the 2003, 2007, and 2010 versions of Office.

Here’s an example of a Secret:

Copy Formatting Using Format Painter

Format Painter copies the formatting (size, font style, color, borders, etc.) from a selected object or text and applies it to the next object or text you click.

To copy formatting in any Office program using the Format Painter:

1. Select the text or object that has the formatting you want to copy.
2. On the Standard toolbar, click on the Format Painter button . (If you don't see the Standard toolbar, go to View, Toolbars, and click Standard.)
3. Select the text or object you want to apply the formatting to, and the formatting appears automatically.

To sign up receive these tips every week in your inbox fill out the form bellow.