Formatting

View:

Sorted by:

Splitting an Excel 2007 Worksheet Window

In Excel 2007, you can split the worksheet window into separate panes and scroll the worksheet in each pane so that you can easily compare data from two separate worksheet locations. You can make the panes [more…]

How to Change Column Width and Row Height in Excel 2007

In Excel 2007, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen [more…]

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

Formatting a Pivot Table in Excel 2007

Excel 2007 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data. The PivotTable Tools Design tab includes special formatting options for [more…]

How to Apply Fill Colors, Patterns, and Gradients to Cells in Excel 2007

You can add emphasis to selected cells in an Excel 2007 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you’re using a black-and-white printer, restrict your [more…]

How to Change the Print Margins in Excel 2007

Print margins indicate how much white space Excel 2007 places between the worksheet data and the edge of the page. The Normal margin settings that Excel applies to a new workbook use top and bottom margins [more…]

Merging and Splitting Cells in Excel 2007

You can merge and center data horizontally or vertically across multiple cells in Excel 2007. You also can unmerge or split a merged cell into its original, individual cells. A common use of merge and [more…]

How to Hide and Unhide Rows and Columns in Excel 2007

You can hide and unhide rows or columns in Excel 2007 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports [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…]

Hiding and Unhiding Excel 2007 Worksheets

In Excel 2007, you can hide any worksheet in a workbook to remove it from view so that others cannot see the data it contains. You can unhide the worksheet at any time. [more…]

Adding a Standard Header or Footer in Excel 2007

Headers and footers typically appear on every page of a report. In Excel 2007, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to [more…]

Freezing Panes in an Excel 2007 Worksheet

The Freeze Panes command in Excel 2007 enables you to freeze portions of a worksheet, typically column and row headings, so that you can view distant parts of the worksheet while the headings remain in [more…]

How to Add a Background Image to an Excel 2007 Worksheet

You can add a graphic image to the background of an Excel 2007 worksheet. The background image (sometimes called a watermark) should be very light in color or use a greatly reduced opacity in order for [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…]

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

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

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

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

Applying a Table Style to an Excel 2007 Table

In Excel 2007, you can apply a predefined table format to a data table. The Format as Table feature displays an extensive Table gallery with the formatting thumbnails divided into three sections — Light [more…]

Listings:1-2526-42

Topics