Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Formatting Excel 2007 Data

View:  
Sorted by:  

How to Change a Cell's Number Format in Excel 2007

Excel 2007 provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret. These number formats include currency, accounting [more…]

Working with the Comma Style in Excel 2007

The Comma Style format (also known as the thousands separator) in Excel 2007 often accompanies the Accounting number format. Like the Accounting format, the Comma format inserts commas in larger numbers [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…]

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…]

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 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…]

How to Insert a Hyperlink to a File or Web Site in Excel 2007

You can insert a hyperlink in Excel 2007 that anyone can click to jump to Web sites or open other files. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic object, such [more…]

Finding the Formatting Toolbar Button Equivalents in Excel 2007

Finding the Excel 2007 Ribbon equivalents for the buttons that were on the Formatting toolbar in earlier versions of Excel is easy. Each button on the Formatting toolbar is prominently displayed on the [more…]

Displaying Numbers in Excel 2007 as Currency

Many Excel 2007 worksheets include financial data, so you’ll likely use either the Currency or Accounting number formats when working with this data. You can easily assign these formats to selected cells [more…]

Formatting Dates in Excel 2007

Excel 2007 provides several different formats in which to display dates and times in a worksheet. Some date formats appear automatically based on how you type a date entry in a cell. For example, if you [more…]

Getting to Know Excel 2007’s Data Types

In Microsoft Office Excel 2007, the worksheet consists of a grid of columns and rows that form cells. You enter three types of data in cells: labels, values, and formulas. [more…]

Using Excel 2007’s Special Number Formats

Excel 2007 includes a nifty number format category called Special that contains four formats: Zip Code, Zip Code + 4, Phone Number, and Social Security Number. These Special number formats, described below [more…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!