Excel Lesson 02

Excel Lesson 2
Changing the Appearance

of a Worksheet
Microsoft Office 2010

Introductory
1 Pasewark & Pasewark

Objectives
Change column widths and row heights.

Position data within a cell by aligning,
Excel Lesson 2
wrapping, rotating, and indenting.

Change the appearance of cells using fonts,
font sizes, font styles, colors, and borders.
Designate the number format used for data
stored in a cell.
2 Pasewark & Pasewark Microsoft Office 2010 Introductory

Objectives (continued)
Use the Format Painter to copy formatting

from one cell to another.
Excel Lesson 2
Apply and clear cell styles.

Find and replace cell formats.

Vocabulary
align font
AutoFit font size
Excel Lesson 2
border font style

cell style Format Painter
clear indent
column heading merge
fill number format

Vocabulary (continued)
orientation
row heading
Excel Lesson 2
style
theme
truncate
wrap text

Resizing Columns and Rows
Resize a column by placing the pointer on

the right edge of the column heading and
Excel Lesson 2
dragging. For a precise column width, enter

the value in the Column Width dialog box.
To change the row height, drag the border of
the row heading or enter a height in the Row
Height dialog box.

Resizing Columns and Rows
(continued)
AutoFit determines the best width for a

column or the best height for a row.
Excel Lesson 2
Place the pointer on the right edge of the

column heading (or below the row heading)
until the pointer changes to a double-headed
arrow. Then, double-click to resize the
column or row to the best fit.

Positioning Data Within a Cell
By default, text you enter in a cell is lined up

along the bottom-left side of the cell, and
Excel Lesson 2
numbers you enter in a cell are lined up

along the bottom-right.
However, you can position data within a cell
in a variety of ways using the buttons on the
Home tab of the Ribbon.

(continued)
Positioning data within a cell
Excel Lesson 2

(continued)
You can align the contents of a cell horizontally

and vertically within the cell. To change the
Excel Lesson 2
alignment of a cell, select the cell and then

click an alignment button on the Home tab.
You can also merge cells which combines them
into one cell.
Indent data within cells by using the Increase
Indent and Decrease Indent buttons on the
Home tab.
(continued)
You can change a cells text orientation.

Text that doesnt fit in a cell is displayed in
Excel Lesson 2
the next cell, if empty. If the next cell contains

data, any text that does not fit is truncated,
or hidden from view.
To see all the text stored in a cell you can
wrap text. The row height increases to
display additional lines.

Changing the Appearance of Cells
A theme is a preset collection of design
elements, including fonts, colors, and effects.
Excel Lesson 2
As you format cells, Live Preview shows the

results of the different formatting options.
A font is the design of text. The default font for
cells is Calibri.
Font size determines the height of characters in
points (default size for cells is 11 points).

(continued)
Font gallery
Excel Lesson 2

(continued)
Bold, italic, and underlining can add emphasis to

the contents of a cell. These features are
Excel Lesson 2
referred to as font styles.

You can use color to emphasize cells. The
default font color is black and the default fill
(background) color is white. Both colors can be
changed.
You can add emphasis to a cell by applying a
border (or line) around its edges.
(continued)
Number formats change the way data looks

in a cell. The actual content you entered is
Excel Lesson 2
not changed.
The default number format is General, which
displays numbers the way you enter them.

(continued)
Number formats
Excel Lesson 2

(continued)
The Format Painter enables you to

copy formatting from one cell and paste
Excel Lesson 2
it to other cells without pasting the first

cells contents.
The format cells dialog box provides access
to all the formatting options available on the
ribbon, as well as some additional options.

Using Styles to Format Cells
A style is a combination of formatting

characteristics.
Excel Lesson 2
A cell style is a collection of formatting

characteristics you apply to a cell or range of
data.
To remove, or clear, all the formatting
applied to a cell or range of cells, use the
Clear button on the Home tab.

Using Styles to Format Cells
(continued)
Cell styles gallery

Excel Lesson 2

Summary
In this lesson, you learned:

If data does not fit in a cell, you can resize the
Excel Lesson 2
columns and rows to make the data easier to read.

You can align, indent, rotate, wrap text, and merge
cells to reposition data in worksheet cells.
You can change the appearance of cells to make the
worksheet easier to read or to create a specific look
and feel. Choose the appropriate fonts, font sizes,
font styles, font and fill colors, and borders.

Summary (continued)
Using a number format enables you to change how
a number is displayed in a cell. No matter which
Excel Lesson 2
number format you select, the actual value stored in

the cell does not change. You can see this by
comparing the formatted value in the active cell with
the value displayed in the Formula Bar.
Format Painter copies all the formatting from one
cell and pastes it to another cell or range without
copying the contents of the cell.
Summary (continued)
The Format Cells dialog box provides all the
number, alignment, font, border, and fill formatting
Excel Lesson 2
options available on the Ribbon, as well as some

additional options.
A style is a combination of formatting
characteristics, such as alignment, font, font size,
font color, fill color, and borders that you can apply
simultaneously. The Cell Styles gallery lets you
quickly apply a style to selected cells or create a
new style.
Summary (continued)
You can use the Find and Replace dialog box to
find and replace cell formatting.
Excel Lesson 2

Excel Lesson 02

Uploaded by

Copyright:

Available Formats

Excel Lesson 02

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Excel Lesson 02

Uploaded by

Copyright:

Available Formats

Excel Lesson 2

Changing the Appearance

Microsoft Office 2010

1 Pasewark & Pasewark

Change column widths and row heights.

wrapping, rotating, and indenting.

2 Pasewark & Pasewark Microsoft Office 2010 Introductory

Use the Format Painter to copy formatting

Apply and clear cell styles.

3 Pasewark & Pasewark Microsoft Office 2010 Introductory

border font style

4 Pasewark & Pasewark Microsoft Office 2010 Introductory

5 Pasewark & Pasewark Microsoft Office 2010 Introductory

Resize a column by placing the pointer on

dragging. For a precise column width, enter

6 Pasewark & Pasewark Microsoft Office 2010 Introductory

AutoFit determines the best width for a

Place the pointer on the right edge of the

7 Pasewark & Pasewark Microsoft Office 2010 Introductory

By default, text you enter in a cell is lined up

numbers you enter in a cell are lined up

8 Pasewark & Pasewark Microsoft Office 2010 Introductory

9 Pasewark & Pasewark Microsoft Office 2010 Introductory

You can align the contents of a cell horizontally

alignment of a cell, select the cell and then

You can change a cells text orientation.

the next cell, if empty. If the next cell contains

11 Pasewark & Pasewark Microsoft Office 2010 Introductory

As you format cells, Live Preview shows the

12 Pasewark & Pasewark Microsoft Office 2010 Introductory

13 Pasewark & Pasewark Microsoft Office 2010 Introductory

Bold, italic, and underlining can add emphasis to

referred to as font styles.

Number formats change the way data looks

15 Pasewark & Pasewark Microsoft Office 2010 Introductory

16 Pasewark & Pasewark Microsoft Office 2010 Introductory

The Format Painter enables you to

it to other cells without pasting the first

17 Pasewark & Pasewark Microsoft Office 2010 Introductory

A style is a combination of formatting

A cell style is a collection of formatting

18 Pasewark & Pasewark Microsoft Office 2010 Introductory

Cell styles gallery

19 Pasewark & Pasewark Microsoft Office 2010 Introductory

In this lesson, you learned:

columns and rows to make the data easier to read.

20 Pasewark & Pasewark Microsoft Office 2010 Introductory

number format you select, the actual value stored in

options available on the Ribbon, as well as some

23 Pasewark & Pasewark Microsoft Office 2010 Introductory

You might also like