Microsoft Office

View:  
Sorted by:  

Word 2007 Mail Merge — Step 3: Building Records

After defining the fields you need for your Word 2007 mail merge, the next step is to complete the address list. To do that, you create a list of records, by entering the data for each field in each record [more…]

Printing Gridlines and Row and Column Headings in Excel 2007

In Excel 2007, you can print gridlines or row numbers and column letters on the page. Selecting these options results in a printout that closely resembles what you see on-screen. This feature is useful [more…]

Applying the Percent Style in Excel 2007

Many Excel 2007 worksheets use percentages to show interest rates, growth rates, inflation rates, and so on. When you apply the Percent Style format to a value that has already been entered in a cell, [more…]

Office 2007: Sharing Data with the Office Clipboard

Cutting, copying, and pasting data may be handy within the same file, but Office 2007 also gives you the ability to cut, copy, and paste data between different programs, such as copying a chart from Excel [more…]

How to Insert Special Characters or Symbols in Word 2007

To insert special characters or symbols in Word 2007 that aren’t on your keyboard, such as em or en dashes, you choose a symbol or character from either the Symbol menu or the Symbol dialog box. [more…]

Using Advanced Filtering in Excel 2007

You can specify complex filtering criteria in Excel 2007 and designate a specific area of your worksheet to manage your criteria selections when filtering table data by using advanced filtering methods [more…]

How to Print Notes Pages in PowerPoint 2007

If you don’t have a computer that can show your PowerPoint slides on a projector and your PowerPoint notes on a separate monitor, you can print your notes on paper and use them while you give your presentation [more…]

Formatting Chart Titles in Excel 2007

When you add chart titles, Excel 2007 uses the Calibri (Body) font for the chart title (in 18-point size) and the x- and y-axis (in 10-point size). To change the font used in a title, or to change any [more…]

How to Crop a Graphic in PowerPoint 2007

You can use PowerPoint’s cropping tool to remove unwanted parts of a graphic in your PowerPoint slide. PowerPoint’s cropping tool doesn’t give you the fine control that some photo editing equipment has [more…]

How to Add a Special Page Number in Word 2007

In a Word 2007 document, you can insert page numbers in the form of numbers, letters, or Roman numerals. To further customize how your page numbers look, just follow a few simple steps. [more…]

Using Excel 2007’s Goal Seek Feature

The Goal Seek feature in Excel 2007 is a what-if analysis tool that enables you to find the input values needed to achieve a goal or objective. To use Goal Seek, you select the cell containing the formula [more…]

Sorting Excel 2007 Data on a Single Column

You may find data in an Excel 2007 worksheet easier to view if it’s sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters [more…]

Outlook 2003: Business Contact Manager

Business Contact Manager (BCM) version 2.0 is a free add-in to Outlook 2003 in the Office Professional and Small Business editions. It's a great tool if you understand how to use it for your benefit and [more…]

Inserting Cells, Rows, or Columns in Excel 2007

If you need to add new data within an existing Microsoft Office Excel 2007 worksheet, you can insert new cells, columns, or rows rather than going through all the trouble of moving and rearranging several [more…]

How to Create an Internet Hyperlink in Word 2007

You can set Word 2007 to automatically create Internet hyperlinks in a document. With this auto-link–creation setting, Word looks for text that looks like a URL and then underlines, colors, and activates [more…]

Focusing on Fields in Access 2003

A field is the place where your data lives; one field holds one piece of data, such as Year or Team.

Because there are so many different kinds of stuff in the world, Access 2003 offers a variety of field [more…]

Creating a Scenario Summary Report in Excel 2007

After using Scenario Manager to add scenarios to a table in a worksheet, you can have Excel 2007 produce a summary report. This report displays the changing and resulting values not only for all the scenarios [more…]

Printing an Excel 2007 Chart

Printing a chart in Excel 2007 is a breeze, but the method you choose for printing the chart depends on whether you want to print an embedded chart (with or without the surrounding worksheet data) or a [more…]

Word 2007 Mail Merge — Step 5: The Final Merge

With the merge fields inserted into the main Word 2007 document and the address list standing by, you’re ready to start your mail merge! [more…]

How to Remove Lines from a Word 2007 Table

You can use the Table Tools Design tab in Word 2007 to remove border lines from your tables. This is useful if you want a table without any lines, such as a one-column, two-row table to put a picture and [more…]

How to Use Outline View in Word 2007

You can use Outline view in Word 2007 to organize your thoughts. Outline view can help you create a simple list of items or it can create a hierarchical list with topics and subtopics. An outline in Word [more…]

Creating a Recurring Appointment in Outlook 2007

Sometimes, once just isn't enough. If you need to keep that weekly appointment with your supervisor or take Scruffy to the groomer once a month, Outlook 2007's Recurring Appointment feature gives you a [more…]

Indenting a Whole Paragraph in Word 2007

Word 2007 can indent every line of a paragraph you type. An indentation is the distance between a margin and the text, not the edge of a page and the text. To have Word indent an entire paragraph, follow [more…]

Arranging Your Outlook 2007 Messages

Nobody gets a little bit of e-mail anymore. If you get one message, you get a ton of 'em. Fortunately, Outlook 2007 offers you a whole bunch of different ways to arrange that mess of messages so you have [more…]

Rotating Cell Data in Excel 2007

Use the Orientation button on the Home tab in Excel 2007 to rotate data in cells. You can rotate data clockwise, counterclockwise, or vertically. Use the Format Cells dialog box to set a more precise orientation [more…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com