Microsoft Office

Sorted by:  

Referring to Values or Formulas in Other Cells in Excel 2007 Formulas

Linking formulas are formulas in Excel 2007 that reference a location in the same worksheet, same workbook, or even a different workbook. When you create a linking formula, it brings forward the constant [more…]

Page Setup Dialog Box Tabs in Word 2007

Use the Page Setup Dialog box to change the margins in a document, to change the paper size, and to change the layout of the document. After calling up the Page Setup Dialog box, you see three tabs: Margins [more…]

Adding a Watermark in Word 2007

Watermarks in Word 2007 documents can be attractive, but they aren’t just about looks: A watermark can be a way of letting the reader know that the document is confidential. Watermarks are most useful [more…]

Customizing the Excel 2007 Quick Access Toolbar

The Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use often. By default, the Quick Access toolbar [more…]

Indenting Cell Data in Excel 2007

In Excel 2007, use the Increase Indent and Decrease Indent buttons in the Alignment group on the Home tab to change the indentation of cell contents. This feature is commonly used to enhance the appearance [more…]

Crunching Numbers with Excel 2007's AVERAGE, MAX, MIN, and MEDIAN Functions

Excel 2007's Statistical functions — including AVERAGE, MAX, MIN, and MEDIAN — are found on a continuation menu accessed from the More Functions command button’s drop-down menu on the Formulas tab. Excel [more…]

How to Create Your Own Fractions Manually in Word 2007

Word 2007’s AutoCorrect feature can build common fractions for you from a small set of existing fraction "characters." However, when you need a different fraction, such as 3/64, you can create it manually [more…]

How to Create a Custom Header or Footer in Excel 2007

Although Excel 2007 provides standard header and footer text that you can select from drop-down menus, you also can create a custom header or footer. In addition to typical header or footer items such [more…]

Exporting Access 2003 Data to XML

For those of you who are already familiar with XML in Access 2002, note that the enhanced XML support in Access 2003 enables you to specify XSL (Extensible Stylesheet Language) transform files when importing [more…]

Inserting Decimal Points Automatically in Excel 2007

If you need to enter a bunch of numbers in an Excel 2007 worksheet that use the same number of decimal places, you can turn on Excel’s Fixed Decimal setting and have the program enter the decimals for [more…]

How to Use the Decimal Tab in Word 2007

You can use the Decimal Tab feature to line up columns of numbers in your Word 2007 documents. Although you could use a right tab to do this, the decimal tab is a better choice. Rather than right-align [more…]

Changing Excel 2007’s Default Font and Font Size

By default, Excel 2007 uses the 11-point Calibri font for cell entries, but you can change this to another font or font size of your choice for all new workbooks. [more…]

Planning Your Day with Excel 2007's NOW, TIME, and TIMEVALUE Functions

Excel 2007's time functions enable you to convert text entries representing times of day into time serial numbers so that you can use them in calculations. Some common time functions include NOW, TIME, [more…]

How to Save an Excel 2007 Workbook

As you work in Microsoft Office Excel 2007, remember to save your work often or you risk losing your Excel data if the computer crashes or the power goes out. When you save a workbook for the first time [more…]

How to Adjust Line Spacing around a Paragraph in Word 2007

You can add space before and after paragraphs in your Word 2007 documents. This is a great way to spread out a list of bullet points or numbered steps without affecting the line spacing within the bullet [more…]

How to Get Help from Word 2007

The easiest way to get help from Word 2007 is to press the F1 key. The cool part about the F1 key is that if you press it while you're performing some obscure task deep inside some strange dialog box or [more…]

Using the Word 2007 Research Task Pane

The Research task pane of Word 2007 is a handy tool for searching reference materials, such as encyclopedias and dictionaries. The Research task pane synonym feature is also an advanced version of the [more…]

How to Insert a Link to Send an E-mail in an Excel 2007 Workbook

You can insert a "mailto" hyperlink in Excel 2007 that anyone can click to create an e-mail to a specific address. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic object [more…]

Get Excel Help for Excel 2007

If you get stuck and have questions about Microsoft Office Excel 2007 features, you can use the Excel Help window to quickly find Excel 2007 help. The Excel Help button — the button with a question mark [more…]

How to Replace Special Characters in Word 2007 Using AutoFormat

The AutoFormat feature in Word 2007 applies automatic formatting to special characters as you type, including smart quotes, fractions, hyperlinks, ordinals, and em dashes. You can choose which characters [more…]

Aligning Excel 2007 Data Horizontally and Vertically

In Excel 2007, you can change the horizontal and vertical alignment of cell data. By default, text is left-aligned, and values or dates are right-aligned. Use the buttons in the Alignment group of the [more…]

How to Lock a PowerPoint 2007 Presentation with a Password

If you don’t want just any Tom, Dick, or Harry to look at your PowerPoint presentation, lock your presentation with a password and give out the password only to people whose opinions you trust. Follow [more…]

Advanced Find and Replace in Excel 2007

In addition to performing a basic find and replace operation in Microsoft Office Excel 2007, you can use advanced search options (in the expanded Find and Replace dialog box) to carry out a more detailed [more…]

How to Convert PowerPoint 97–2003 Presentations to 2007

When you open a PowerPoint presentation made in an earlier version of PowerPoint, the program switches to compatibility mode. PowerPoint 2007 shuts down features that weren’t a part of earlier versions [more…]

How to Change Text Alignment and Orientation in a Word 2007 Table

You can change text alignment and orientation in a Word 2007 table. Word makes it easy by including various commands in the Alignment group of the Tool Tables Layout tab on the Ribbon. [more…]

Sign Up for RSS Feeds

Computers & Software