Page 43 - Excel Workbook for Dummies

06_798452 ch02.qxp 3/13/06 7:34 PM Page 26
26 Part I: Creating Spreadsheets

2. Restore the height of Row 2 to its original height with AutoFit.
Double-click the lower border of a row in the row header to modify its height
using AutoFit or place the cell cursor somewhere in the row and choose
Format➪Row➪AutoFit.

Cell Formatting Techniques

Cell formatting can run the gamut from changing the font, color, attribute, and/or align-
ment of a cell entry to the color, borders, and protection status of the cell itself. You
can accomplish much of the formatting in a typical spreadsheet with the buttons on
the Formatting toolbar. The rest you can accomplish with the options available on the
various tabs of the all-important Format Cells dialog box.

The first rule of formatting is to remember to select all the cells that need formatting
before you select the desired button on the Formatting toolbar or an option on one of
the tabs in the Format Cells dialog box.

Formatting cells with the Formatting toolbar

The Formatting toolbar shown in Figure 2-1 contains the tools you most often need
when formatting your average spreadsheet. These tools are arranged into six groups of
buttons (from left to right across the toolbar):

Font and Font Size drop-down buttons
Bold, Italic, and Underline attribute buttons
Left, Right, Center, and Merge and Center alignment buttons
Currency, Percent, and Comma Style buttons along with Increase Decimal and
Decrease Decimal buttons
Decrease Indent and Increase Indent buttons
Borders, Fill Color, and Font Color buttons

Currency Style Comma Style
Align Right Decrease Decimal
Italic Increase Indent
Figure 2-1:
You can do Font Size Align Left Fill Color
most of your
everyday
formatting
with the
tools on the
Font Bold Center Borders
Formatting
toolbar. Underline Decrease Indent
Merge and Center Increase Decimal

Percent Style Font Color