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

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

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

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

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

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

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

Hiding Graphic Objects in Excel 2007

The Selection and Visibility task pane in Excel 2007 enables you to control whether various graphic objects in the worksheet are hidden or displayed. Hiding objects can make it easier to select other objects [more…]

Listings:1-2526-28

Related Topics