UNIT 3 – EXCEL Lesson 2 – Changing the Appearance of a

```INTRODUCTORY MICROSOFT
EXCEL
Lesson 2 – Changing the
Appearance of a Worksheet
Microsoft Office 2003:
Introductory
1
Pasewark & Pasewark
Excel – Lesson 2
Objectives
2



Change column width and row height.
Position text within a cell by wrapping,
rotating, indenting, and aligning.
Change the appearance of cells using fonts,
styles, colors, and borders.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Objectives (cont.)
3




Designate the format of a cell to
accommodate different kinds of text and
numerical data.
Apply and paint formats.
Create and use styles.
Find and replace cell formats.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Terms Used in This Lesson
4





AutoFormat
Indented text
Rotated text
Style
Wrapped text
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
When a Cell Is Too Small
5
When a cell is too small, Excel
 Displays a series of number signs (######).
 Cuts off the data.
 Lets the data run outside of the column.
 Converts the data to a different numerical
form (e.g., exponential form).
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Change Column Width and
Row Height
6


To change the width or height, place the
mouse pointer on the right edge of a column
or top of a row. The pointer will change to a
Widen a column or row by dragging the
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Position Text Within a Cell

Text may be positioned by
–
–
–
–
–
–
7
Wrapping
Rotating
Indenting
Justifying
Centering
Merging
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Designate the Format of a Cell

The format of a cell may be changed by
using different
–
–
–
–
–
8
Fonts
Font sizes
Styles
Colors
Borders
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Apply and Paint Formats
9

You may paint a format that exists in
another area of the worksheet.
–
Select a cell with the desired format.
–
Click the Format Painter button.
–
Drag the cells that you want to apply
the format to.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Designate the Format of a Cell
Excel – Lesson 2

Cells may be formatted to accommodate
different kinds of data.
–
–
–
–
–
10
General
Number
Currency
Accounting
Date
–
–
–
–
–
Microsoft Office 2003: Introductory
Time
Percentage
Fraction
Scientific
Text
Pasewark & Pasewark
Excel – Lesson 2
Designate the Format of
a Cell (cont.)
11
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Create and Use Styles
12


A style is a combination of formatting
characteristics such as alignment, font,
border, or pattern.
You may apply a style that has already
been created in Excel.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Clearing Cell Formats
13

Remove cell formats by selecting the cell or
range, choosing Clear on the Edit menu,
and then clicking Formats on the submenu.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
AutoFormats
14


An AutoFormat is a collection of fonts,
patterns, and alignments that can be
applied to a range of data.
AutoFormats are applied by choosing the
AutoFormat command on the Format
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Find and Replace Cell Formats
15


You may also find specific formats in a
workbook and replace the format with
another format.
For example, you may replace all italicized
text with bolded text.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Summary
16



You can wrap, rotate, indent, or align the
position of text within the cells.
Font, font size, and style (bolding, italicizing,
and underlining) may be changed. Color and
A cell may be changed to accommodate
data in a variety of numerical formats.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Summary (cont.)
17


Formatting characteristics such as
alignment, font, border, or pattern may be
applied by using the Styles command.
Format painting copies the format of a
worksheet cell without copying the contents
of the cell.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
Excel – Lesson 2
Summary (cont.)
18


Various collections of fonts, patterns, and
alignments can be applied to a range of
data by using the AutoFormat command.
The Find and Replace command may be
used to change cell formats.
Microsoft Office 2003: Introductory
Pasewark & Pasewark
```