copyright © 2004 prentice hall. all rights reserved. 1 committed to shaping the next generation of...
TRANSCRIPT
Copyright © 2004 Prentice Hall. All rights reserved.1Committed to Shaping the Next Generation of IT Experts.
Go! With Microsoft Office (Excel) 2003
CHAPTER 3Format a Worksheet
Copyright © 2004 Prentice Hall. All rights reserved.2
Objectives
Change Number Format Change Alignment of Cell Contents Apply Cell Formatting Apply Workbook Formatting Print Gridlines and Row and Column
Headings View and Insert Comments in a Cell
Copyright © 2004 Prentice Hall. All rights reserved.3
SCREEN BEAN INTRODUCTION — TEXT: Let’s look at different ways we can format numbers
Change Number Formats
Let’s look at different ways we
can format numbers
Copyright © 2004 Prentice Hall. All rights reserved.4
Change Number Format
Number Format Types: General Number Currency Accounting Date Time
Percentage Fraction Scientific Text Special Custom
Copyright © 2004 Prentice Hall. All rights reserved.5
Change Number Format (continued)
GRAPHIC showing: Format Cells
Dialog box
Active cell with numeric content
Format Cells dialog box with format Category list
Copyright © 2004 Prentice Hall. All rights reserved.6
GRAPHIC showing: Difference in Accounting and Currency styles
Change Number Format (continued)
Accounting format guarantee numbers align correctly
Difference in dollar sign alignment
Copyright © 2004 Prentice Hall. All rights reserved.7
SCREEN BEAN INTRODUCTION — TEXT: Understand Alignment in Excel
Change Alignment of Cell Contents
UnderstandCell Content
AlignmentIn
Excel
Copyright © 2004 Prentice Hall. All rights reserved.8
Change Alignment of Cell Contents
GRAPHIC showing example of horizontal alignments
Many options for horizontal alignment
Copyright © 2004 Prentice Hall. All rights reserved.9
GRAPHIC showing: Format Cells dialog box Alignment tab
Change Alignment of Cell Contents (continued)
For selected range of text values…
…Center text formatting is chosen
Copyright © 2004 Prentice Hall. All rights reserved.10
Change Alignment of Cell Contents (continued) Horizontal
Alignment Options Left (Indent) Center Right (Indent) Fill Justify Center Across
Selection Distributed (Indent)
Vertical Alignment Options Top Center Bottom Justify Distributed
Copyright © 2004 Prentice Hall. All rights reserved.11
Change Alignment of Cell Contents (continued)
Other Alignment Options Orientation
Stacked or set a text angle Setting degrees by a numeric spin box
or graphically Text Control
Wrapping text, shrinking text, and merging cells
Text Direction Left-to-right or right-to-left
Copyright © 2004 Prentice Hall. All rights reserved.12
SCREEN BEAN INTRODUCTION — TEXT: Font style, Emphasis, Orientation, Patterns and Borders
Apply Cell Formatting
Font style
Orien
tation
Borders
Patterns
Emphasis
Copyright © 2004 Prentice Hall. All rights reserved.13
Apply Cell Formatting
GRAPHIC showing: Formatting toolbar features and sample fonts
Font size list
Font list
Font style buttons
Common fonts
Copyright © 2004 Prentice Hall. All rights reserved.14
Apply Cell Formatting (continued)
Alignment
Text control options
Text orientation
Copyright © 2004 Prentice Hall. All rights reserved.15
Apply Cell Formatting (continued)
GRAPHCI showing: Format Cells dialog’s Border tab
Preset border formats
Border options
Line and color specifications
Copyright © 2004 Prentice Hall. All rights reserved.16
GRAPHIC showing: Format Cells dialog’s Patterns tab
Apply Cell Formatting (continued)
Color and patterns palette
Copyright © 2004 Prentice Hall. All rights reserved.17
GRAPHIC showing: Page Setup dialog’s Margins tab
Apply Cell Formatting (continued)
Margin settings
Centering options
Copyright © 2004 Prentice Hall. All rights reserved.18
SCREEN BEAN INTRODUCTION — TEXT: There are many different workbook formatting options available in Excel
Apply Workbook Formatting
There are many different
workbook formatting
options available in Excel
Copyright © 2004 Prentice Hall. All rights reserved.19
GRAPHIC showing: Inserting current date into header
Apply Workbook Formatting
Code entered by pressing Date button
Date button
Copyright © 2004 Prentice Hall. All rights reserved.20
GRAPHIC showing: Inserting a picture into a header)
Apply Workbook Formatting (continued)
Insert Picture button
Code entered by pressing Insert Picture button
Copyright © 2004 Prentice Hall. All rights reserved.21
GRAPHIC showing: Page Setup dialog box’s Sheet tab)
Apply Workbook Formatting (continued)
Options for printing sheet’s gridlines, row and column headings, and black and white
Copyright © 2004 Prentice Hall. All rights reserved.22
GRAPHIC showing: Viewing a cell’s comment)
Apply Workbook Formatting (continued)
Red triangle in top right corner of a cell indicates a comment
Comment appears when mouse pointer is positioned over the cell