Formatting Excel 2007 Cells & Worksheets

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

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

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

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

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

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 Wrap Excel 2007 Data to See All the Text

Use the Wrap Text button on the Home tab of Excel 2007 to wrap lengthy text in a cell by displaying it on multiple lines within the cell. This feature helps you avoid the problem of having to abbreviate [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…]

Renaming an Excel 2007 Worksheet

The sheet names that Excel 2007 uses for the tabs in a workbook (Sheet1 through Sheet3) are not very descriptive. Luckily, you can easily rename a worksheet tab to whatever helps you remember what you [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…]

Using Excel 2007’s Cell Comment Feature

You can add a cell comment — an electronic version of a sticky note — to any cell in an Excel 2007 worksheet. Comments allow those reviewing a worksheet to provide instruction, for example, noting how [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…]

Applying a Design Theme to an Excel 2007 Workbook

With themes, Excel 2007 introduces a whole new way to uniformly format all the text and graphics in a worksheet. You can do this by simply clicking the thumbnail of the new theme you want to use in the [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…]

Previewing Excel 2007 Formatting with Live Preview

Excel 2007 includes the Live Preview feature, which enables you to see how a new font, font size, table style, or cell style would look on your selected data before you actually apply it. This feature [more…]

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.