Data

View:

Sorted by:

Applying Conditional Formatting in Excel 2007

Excel 2007's conditional formatting lets you change the appearance of a cell based on its value or the value of another cell. You specify certain conditions, and when those conditions are met, Excel applies [more…]

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

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

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

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

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

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

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

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

How to Add Data Visualizations in Excel 2007

In Excel 2007, you can instantly apply data visualizations to cells by using data bars, color scales, and icon sets that help you quickly understand data variations in your tables. Excel provides several [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…]

Copying Excel 2007 Formatting with Format Painter

Use the Format Painter button on the Home tab of the Excel 2007 Ribbon to save time when copying formatting between cells in your worksheets. You also can use Format Painter to quickly copy the width of [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…]

Formatting Fonts in Excel 2007

Excel 2007 includes several ways to apply formatting to the fonts in your worksheets. You can change the font face, font size, and font color using the commands in the Font group on the Home tab. [more…]

Related Topics