Chapter 8. Formatting the Worksheet

In this section:

Microsoft Office Excel 2007 enables you to change your worksheets’ appearance and structure to display your data effectively. For example, you can make rows and columns surrounding your data wider so your figures are separated from the worksheet’s other contents. You can also move entire rows or columns to different locations in the workbook, such as when a worksheet’s data columns are in a different order than those of a related paper form. If you want to call attention to one of your worksheets, perhaps one that contains new data your boss should review, you can change the color of that worksheet’s sheet tab so that it stands out within the workbook.

Applying Workbook Themes

Designing attractive Excel worksheets challenges even the most advanced users. Prior to Excel 2007, you could only format your worksheets quickly by using a series of not-very-inspiring AutoFormats. Excel 2007, by contrast, comes with a wide variety of attractive themes that you can apply to your worksheets. But you’re not limited to the themes included when you install Excel! You can create your own themes, find many more themes on the Microsoft Office Templates Web site, and trade themed workbooks with other users.

Apply a Workbook Theme

  1. Click the Page Layout tab.

  2. In the Themes group on the ribbon, click Themes.

  3. Click the theme you want to apply.

    Apply a Workbook Theme

Change Colors within a Theme

  1. Click the Page Layout tab.

  2. In the Themes group on the ribbon, click Colors.

  3. Click the color scheme you want to apply.

    Change Colors within a Theme

Change Fonts within a Theme

  1. Click the Page Layout tab.

  2. In the Themes group on the ribbon, click Fonts.

  3. Click the font scheme you want to apply.

    Change Fonts within a Theme

Change Effects within a Theme

  1. Click the Page Layout tab.

  2. In the Themes group on the ribbon, click Effects.

  3. Click the effects scheme you want to apply.

    Change Effects within a Theme

Create a New Workbook Theme

  1. Format your worksheet using the colors, fonts, and effects you want to include in your theme.

  2. Click the Page Layout tab.

  3. In the Themes group on the ribbon, click Themes.

  4. Click Save Current Theme.

  5. Type a name for your theme.

  6. Click Save.

    Create a New Workbook Theme
    Create a New Workbook Theme

    Tip

    Tip

    You can find a collection of existing themes and themed documents on the Microsoft Office Online: Templates home page. To display that Web page, click the Page Layout tab, click Themes, and then click Search Office Online.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.119.29.105