INTRODUCTORY MICROSOFT EXCEL Lesson 2 Changing the Appearance of a Worksheet - PowerPoint PPT Presentation

Loading...

PPT – INTRODUCTORY MICROSOFT EXCEL Lesson 2 Changing the Appearance of a Worksheet PowerPoint presentation | free to view - id: 14ff5a-MjZiN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

INTRODUCTORY MICROSOFT EXCEL Lesson 2 Changing the Appearance of a Worksheet

Description:

Microsoft Office 2003: Introductory Pasewark & Pasewark. Objectives. Change column width and row height. ... Justifying. Centering. Merging. 8. Excel Lesson 2 ... – PowerPoint PPT presentation

Number of Views:202
Avg rating:3.0/5.0
Slides: 19
Provided by: willi345
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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.
About PowerShow.com