INTRODUCTORY MICROSOFT EXCEL Lesson 2 Changing the Appearance of a Worksheet

1
INTRODUCTORY MICROSOFT EXCELLesson 2 Changing
the Appearance of a Worksheet
2
Objectives

• 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.

3
Objectives (cont.)

• 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.

4
Terms Used in This Lesson

• AutoFormat
• Indented text
• Rotated text
• Style
• Wrapped text

5
When a Cell Is Too Small

• 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).

6
Change Column Width and Row Height

• 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 double-headed
  arrow.
• Widen a column or row by dragging the
  double-headed arrow.

7
Position Text Within a Cell

• Text may be positioned by
• Wrapping
• Rotating
• Indenting
• Justifying
• Centering
• Merging

8
Designate the Format of a Cell

• The format of a cell may be changed by using
  different
• Fonts
• Font sizes
• Styles
• Colors
• Borders

9
Apply and Paint Formats

• 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.

10
Designate the Format of a Cell

• Cells may be formatted to accommodate different
  kinds of data.

• Time
• Percentage
• Fraction
• Scientific
• Text

• General
• Number
• Currency
• Accounting
• Date

11
Designate the Format of a Cell (cont.)
12
Create and Use Styles

• 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.

13
Clearing Cell Formats

• Remove cell formats by selecting the cell or
  range, choosing Clear on the Edit menu, and then
  clicking Formats on the submenu.

14
AutoFormats

• 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 menu.

15
Find and Replace Cell Formats

• 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.

16
Summary

• 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
  borders may also be added.
• A cell may be changed to accommodate data in a
  variety of numerical formats.

17
Summary (cont.)

• 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.

18
Summary (cont.)

• 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.