Microsoft Excel 2003 Illustrated Introductory

1
Microsoft Excel 2003 Illustrated Introductory
Formatting

• A Worksheet

2
Objectives

• Format values
• Use fonts and font sizes
• Change attributes and alignment
• Adjust column widths

3
Objectives

• Insert and delete rows and columns
• Apply colors, patterns, and borders
• Use conditional formatting
• Check spelling

4
Formatting Values

• Formatting determines how labels and values
  appear in cells
• Bold, italic, dollar signs, commas, etc.
• Formatting does not change the data only its
  appearance
• Select a cell or a range, then apply formatting

5
Formatting Values (cont.)
New date format
6
Formatting Values (cont.)

• Using the Format Painter
• The Format Painter allows you to copy all
  formatting attributes of selected cells and apply
  to other cells
• Use to copy multiple format settings or
  individual ones

7
Using Fonts and Font Sizes

• A font is the name for a collection of similar
  characters with a specific design (letters,
  numerals, symbols, and punctuation marks)
• The default font in Excel is 10-point Arial
• The physical size of text is called font size
• Measured in points
• 1 point 1/72 of an inch

8
Using Fonts and Font Sizes (cont.)
Font and size of active cell or range
9
Using Fonts and Font Sizes (cont.)

• Inserting Clip Art
• Clip art is a collection of graphic images
• Stored in the Insert Clip Art task pane
• Clips are media files, including graphics,
  photographs, sounds, movies, and animations that
  come with Excel
• Add clips to a worksheet using the Clip Art
  command on the Insert menu

10
Using Fonts and Font Sizes (cont.)

• Inserting Clip Art (cont.)
• Search for clips using keywords.

Enter keyword
Clip collections
Results of a clip search
11
Changing Attributes and Alignment

• Attributes are styling formats such as bold,
  italics, and underlining
• Alignment determines the position of data in a
  cell
• Left, right, or center
• Apply attributes and alignment options from the
  Formatting toolbar

12
Changing Attributes and Alignment (cont.)
Bold button
Underline button
Center button
Title centered
Column headings centered, bolded, and underlined
13
Changing Attributes and Alignment (cont.)

• Rotating and indenting cell entries
• Rotate data within a cell by changing its
  alignment
• Orientation changes from its horizontal alignment
• Indent data to the left or right within a cell
• Use the Increase Indent button or the Decrease
  Indent button

14
Changing Attributes and Alignment (cont.)

• Using AutoFormat
• 17 predefined formats
• Designed with labels on the left column and top
  row, and totals on the bottom row and right
  column
• Select data, then click AutoFormat on the Format
  menu

15
Adjusting Column Widths

• Adjust column widths to accommodate data
• Default column width is 8.43 characters wide (a
  little less than one inch)
• One or more columns can be adjusted using the
  mouse or the Column command on the Format menu

16
Adjusting Column Widths (cont.)

• Change column widths with the mouse
• Move the column heading, gray box at the top of
  each column

Resize pointer
Column headings that need adjusting
17
Adjusting Column Widths (cont.)

• Specifying row height
• Customize row height to improve readability
• Measured in points, same unit of measure used for
  fonts
• Row height should exceed the font size
• Excel usually adjusts row heights automatically

18
Inserting and Deleting Rows and Columns

• Right-click a cell to open the Insert dialog box
• Insert a column or row
• Shift cells in the active column right or in the
  active row down
• Excel inserts rows above the cell pointer and
  insert columns to the left of the cell pointer

19
Inserting and Deleting Rows and Columns (cont.)

• Deleting rows and columns
• Select the row or column heading, click Edit on
  the menu bar, then click Delete

Inserted row will appear above selected row
20
Inserting and Deleting Rows and Columns (cont.)

• Adding and editing comments
• You and other users can add comments to
  worksheets
• Click a cell, click Insert on the menu bar, then
  click Comment
• A small red triangle appears in the upper right
  hand corner
• Point to the red triangle to view the comment
• Click the cell with the comment, click Insert on
  the menu bar, then click Edit Comment

21
Applying Colors, Patterns, and Borders

• Use colors, patterns, and borders to enhance a
  worksheets appearance.
• Add using the Pattern and Borders tabs in the
  Format Cells dialog box
• or
• Add using the Borders and Color buttons on the
  Formatting toolbar
• Apply to a cell, a range, or to cell contents

22
Applying Colors, Patterns, and Borders (cont.)
Background color
Font color
23
Using Conditional Formatting

• Excel can format cells based on specific results
• The automatic application of formatting
  attributes on cell values is called conditional
  formatting
• Values above a certain number can be one color
  and values below a certain number can be another
  color

24
Using Conditional Formatting (cont.)

• The Conditional Formatting dialog box
• Use logical operators such as greater than or
  not equal to.
• Define up to three different conditions and apply
  different formatting attributes

25
Using Conditional Formatting (cont.)
Conditional formatting options
26
Checking Spelling

• Spelling checker scans the worksheet and flags
  possible mistakes and suggests corrections
• To check other worksheets in a workbook, display
  the worksheet and run the spelling checker again
• Add words that are spelled correctly that are not
  recognized by the spelling checker

27
Checking Spelling (cont.)

• Using e-mail to send a workbook
• Send as an attachment
• Click File on the menu bar, point to Send to,
  then click Mail Recipient (as Attachment)

28
Summary

• Use formatting tools to enhance the appearance of
  a worksheet
• Change fonts and font sizes
• Adjust column widths
• Create conditional formatting
• Check spelling