Microsoft Office

Sorted by:  

Changing the Default File Location in Excel 2007

When you first start using Microsoft Office Excel 2007, Excel wants to save files in the My Documents (Windows XP) or the Documents (Windows Vista) folder under your user name on your hard drive. So, for [more…]

What Are the Different Kinds of Charts in PowerPoint 2007?

PowerPoint offers 11 chart categories. Each type of PowerPoint chart gives you a different kind of picture of the information in it. What kind of chart do you need in your PowerPoint Presentation? Perhaps [more…]

Selecting Cells in Excel 2007

Before you can enter your worksheet data in Microsoft Office Excel 2007, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell [more…]

How to Change the CASE of Your Text in Word 2007

You can change the case of text in Word 2007 by using the Change Case button. The choices include UPPERCASE, lowercase, Sentence case, Capitalize Each Word, and even tOGGLE cASE. [more…]

Fixing Capitalization with Excel 2007's UPPER, LOWER, and PROPER Functions

Excel 2007 includes several Text functions (such as UPPER, LOWER, PROPER, VALUE, TEXT, and DOLLAR) that enable you to perform operations on text entries in a worksheet. These functions are located in the [more…]

How to Use Paste Options and Paste Special in Word 2007

Word 2007 features Paste Options and Paste Special to help you paste blocks of text into your text. One helps you select formatting for a selected block, and the other helps you use a specific format when [more…]

How to Indent the First Line of a Paragraph in Word 2007

Word 2007 can automatically indent the first line of every 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 automatically [more…]

Deleting Cells and Data in Excel 2007

In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can [more…]

How to Animate a PowerPoint 2007 Object

One common type of animation in PowerPoint is the entrance effect for text that appears on the slide. This is especially useful for bullet lists because it lets you display the list one item at a time. [more…]

How to Adjust Column and Row Size in a Word 2007 Table

You can adjust the column and row sizes in your Word 2007 tables. The Columns dialog box lets you adjust column width and the space between columns. The Distribute commands ensure that your tables have [more…]

Design Slides with PowerPoint Themes

A theme is a set of design elements you can apply to slides in your presentation. Microsoft PowerPoint 2007 includes 20 carefully crafted themes you can use to give your PowerPoint presentations a professional [more…]

How to Paste an Excel Table in Word 2007

When you want to paste an Excel table into your Word 2007 document, you can use the Paste Special command to position the table in the document. [more…]

How to Accept or Reject Changes in Word 2007 Documents

After the editing and rewriting process is complete, remove tracked changes in Word 2007 to make your document clean and final. You can accept or reject a suggested change, leaving the text pristine and [more…]

Rotating a 3-D Excel Chart

Admit it — 3-D charts in Excel look really cool! Working with 3-D charts in Excel requires merely a basic understanding of height, width, and depth. The 3-D View dialog box lets you change the 3-D settings [more…]

How to Insert a Hyperlink to a Different Cell in an Excel 2007 Workbook

You can insert a hyperlink in Excel 2007 that anyone can click to jump to a different cell in the current workbook. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic [more…]

How to Add Cell Borders in Excel 2007

In Excel 2007, you can add borders to certain cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group of the Home tab to add borders of varying styles and [more…]

Enabling Security Features in Outlook 2007

Consider security when it comes to Outlook 2007 e-mail and personal information. If you work in a corporation, you may be required by law to maintain certain standards of security over the Outlook e-mail [more…]

Where to Put a Page Number in Word 2007

Word 2007 can automatically number your pages and let you place the page number anywhere on the page (top, bottom, or sides) in a variety of formats. If you delete or renumber a page, Word automatically [more…]

Examining Investment Value with Excel 2007's PV and FV Functions

The most common financial functions in Excel 2007 — PV (Present Value) and FV (Future Value) — use the same arguments. The key to using these financial functions is to understand the terminology used by [more…]

Adding a Text Box in Word 2007

A text box is a special type of shape designed to place text in your Word 2007 document without regard to the normal page margins. The most common use of text boxes is to add bits of text to drawings. [more…]

Using Drag and Drop in Excel 2007

Drag and drop is a mouse technique that you can use in Office Excel 2007 to pick up a cell selection and drop it into a new place on the worksheet. Although drag and drop is primarily a technique for moving [more…]

How to Protect Your Word 2007 Document

In Word 2007, you can protect your documents from being modified, or changed, by others. The easiest way to protect your document is to use the Protect Document command button. [more…]

Working in Excel 2007’s Page Layout View

Excel 2007’s new Page Layout gives you an instant view of how the printed Excel page will look. You activate this view by clicking the Page Layout View button [more…]

Write Equations in PowerPoint 2007

Use the Equation Editor to place mathematical equations and expressions on PowerPoint slides. The equations you draw become embedded PowerPoint objects so you can edit them without leaving PowerPoint, [more…]

Change the Layout of Master Slides in PowerPoint 2007

Changing the layout of a PowerPoint master slide entails changing the position and size of text frames and content frames on your PowerPoint slides, as well as removing these frames. PowerPoint content [more…]

Sign Up for RSS Feeds

Computers & Software