Transcript Contents

© Paradigm Publishing, Inc.
1
Excel 2010
Level 1
Unit 1 Preparing and Formatting a
Worksheet
Chapter 3 Formatting an Excel Worksheet
© Paradigm Publishing, Inc.
2
Formatting an Excel Worksheet
Quick Links to Presentation Contents





Change Column Width
Change Row Height
Insert Rows
Insert Columns
Delete Cells, Rows, or
Columns
 Clear Data in Cells
 CHECKPOINT 1






© Paradigm Publishing, Inc.
3
Apply Formatting
Apply a Theme
Format Numbers
Use the Format Cells Dialog Box
Format with Format Painter
Hide and Unhide Columns
and/or Rows
 CHECKPOINT 2
Change Column Width
To change column width:
1. Drag the column boundary.
column
boundary
© Paradigm Publishing, Inc.
4
Change Column Width…continued
To change column width of selected adjacent columns:
1. Select the desired columns.
2. Drag one of the column boundaries within the
selected columns.
column
boundary
© Paradigm Publishing, Inc.
5
Change Column Width…continued
To change column width at
the Column Width dialog
box:
1. Click the Format button.
2. Click the Column Width
option at the drop-down
list.
3. Type the desired width.
4. Click OK.
© Paradigm Publishing, Inc.
Column Width
dialog box
6
Change Row Height
To change row height:
1. Drag the row boundary.
row
boundary
© Paradigm Publishing, Inc.
7
Change Row Height…continued
To change row height of
selected adjacent rows:
1. Select the desired rows.
2. Drag one of the row
boundaries within the
selected rows.
row
boundary
© Paradigm Publishing, Inc.
8
Change Row Height…continued
To change row height at the
Row Height dialog box:
1. Click the Format button.
2. Click the Row Height
option at the drop-down
list.
3. Type the desired height.
4. Click OK.
© Paradigm Publishing, Inc.
Row Height
dialog box
9
Insert Rows
To insert a row with the
Insert button:
1. Select the row below
where the row is to
be inserted.
2. Click the Insert
Insert
button in the Cells
button
group in the Home
tab.
© Paradigm Publishing, Inc.
10
Insert Rows…continued
To insert a row with the
Insert Sheet Rows option:
1. Select the row below
where the row is to be
inserted.
2. Click the Insert button
arrow in the Cells group
in the Home tab.
3. Click the Insert Sheet
Rows option.
© Paradigm Publishing, Inc.
Insert Sheet
Rows option
11
Insert Rows…continued
To insert a row at the
Insert dialog box:
1. Click the Insert button
arrow in the Cells
group in the Home Insert Cells
option
tab.
2. Click the Insert Cells
option.
3. Click the Entire row
option in the Insert
dialog box.
4. Click OK.
© Paradigm Publishing, Inc.
12
Insert Columns
To insert a column with the
Insert Sheet Columns
option:
1. Select the column to the
right where the column
is to be inserted.
2. Click the Insert button
arrow in the Cells group
in the Home tab.
3. Click the Insert Sheet
Columns option.
© Paradigm Publishing, Inc.
Insert Sheet
Columns option
13
Insert Columns…continued
To insert a column at the
Insert dialog box:
1. Click the Insert button
arrow in the Cells
Entire
group in the Home column
tab.
option
2. Click the Insert Cells
option.
3. Click the Entire
column option in the
Insert dialog box.
4. Click OK.
© Paradigm Publishing, Inc.
14
Delete Cells, Rows, or Columns
To delete a cell:
1. Make the cell active.
2. Click the Delete button
arrow in the Cells group
in the Home tab.
3. Click the Delete Cells
option at the drop-down
list.
4. At the Delete dialog box,
specify what you want
deleted.
5. Click OK.
© Paradigm Publishing, Inc.
Delete
dialog box
15
Clear Data in Cells
To clear data in cells:
1. Select the desired cells.
2. Click the Clear button in
the Editing group in the
Home tab.
3. Click the Clear Contents
option at the drop-down
list.
Clear Contents
option
© Paradigm Publishing, Inc.
16
1) To display the Column Width
dialog box, click the Format
button in this tab.
a. File
b. Home
c. Insert
Answer
d. Page Layout
3) By default, a column is inserted
here in relation to the column
containing the active cell.
a. to the top
b. to the bottom
c. to the right
Answer
d. to the left
2) A vertical inch contains
approximately how many points?
a. 12
b. 24
c. 48
d. 72
4) To delete cell contents but not the
cell, make the cell active and then
press this key.
a. Enter
b. Tab
c. Insert
d. Delete
Answer
Next Question
Answer
Next Question
Next Question
© Paradigm Publishing, Inc.
Next Slide
17
Apply Formatting
 You can apply a variety of formatting to cells in a
worksheet with buttons in the Font group in the Home
tab.
Font
group
© Paradigm Publishing, Inc.
18
Apply Formatting…continued
To change the font:
1. Make the desired
cell active or select
the desired cells.
2. Click the Font button
arrow in the Font
group in the Home
tab.
3. Scroll down the
Font button
drop-down gallery, arrow
and then click the
desired font.
© Paradigm Publishing, Inc.
19
Apply Formatting…continued
To add a border:
1. Make the desired
cell active or select
the desired cells.
2. Click the Borders
button arrow in the
Font group in the
Home tab.
3. Click the desired
option at the dropdown list.
© Paradigm Publishing, Inc.
Borders button
arrow
20
Apply Formatting…continued
To apply fill color:
1. Make the desired cell active or select the desired cells.
2. Click the Fill Color button arrow in the Font group in
the Home tab.
3. Click the desired color option.
Fill Color
button arrow
© Paradigm Publishing, Inc.
21
Apply Formatting…continued
To change the font color:
1. Make the desired cell
active or select the
desired cells.
2. Click the Font Color
button arrow in the Font
group in the Home tab.
3. Click the desired color at
the drop-down color
palette.
© Paradigm Publishing, Inc.
Font Color
button arrow
22
Apply Formatting…continued
 Double-click in a cell and then select data within the
cell and the Mini toolbar displays in a dimmed fashion
above the selected data.
Mini toolbar
© Paradigm Publishing, Inc.
23
Apply Formatting…continued
 Enter words or text combined with numbers in a cell
and the text is aligned at the left edge of the cell.
 Enter numbers in a cell and the numbers are aligned at
the right side of the cell.
Alignment
group
© Paradigm Publishing, Inc.
24
Apply Formatting…continued
To merge each row of the
selected cells:
1. Select the desired cells.
2. Click the Merge &
Center button arrow in
the Alignment group in
the Home tab.
3. Click the Merge Across
option at the dropdown list.
© Paradigm Publishing, Inc.
Merge Across
option
25
Apply Formatting…continued
To rotate text:
1. Make the desired cell
active or select the
desired cells.
2. Click the Orientation
button in the Alignment
group in the Home tab.
3. Click the desired option
at the drop-down list.
© Paradigm Publishing, Inc.
Orientation
button
26
Apply a Theme
To apply a theme:
1. Click the Page Layout
tab.
2. Click the Themes button
in the Themes group.
3. Click the desired theme
at the drop-down
gallery.
Themes
button
© Paradigm Publishing, Inc.
27
Format Numbers
To format numbers
Number Format
using the Number
button arrow
Format button:
1. Make the desired
cell active or select
the desired cells.
2. Click the Number
Format button arrow
in the Number group
in the Home tab.
3. Click the desired
number format at
the drop-down list.
© Paradigm Publishing, Inc.
28
Format Numbers…continued
To format numbers using
the Format Cells dialog
box:
1. Make the desired cell
active or select the
desired cells.
2. Click the Number group
dialog box launcher in
the Home tab.
3. Click the desired
number format at the
Number tab.
4. Click OK.
© Paradigm Publishing, Inc.
Number tab
29
Format Numbers…continued
Click this category
To apply this number formatting
Number
Specify number of decimal places and whether or not a
thousand separator should be used; choose the display
of negative numbers; right-align numbers in cell.
Currency
Apply general monetary values; dollar sign is added as
well as commas and decimal points, if needed; rightalign numbers in cell.
Accounting
Line up the currency symbol and decimal points in a
column; add dollar sign and two digits after a decimal
point; right-align numbers in cell.
Date
Display date as date value; specify the type of
formatting desired by clicking an option in the Type list
box; right-align date in cell.
Time
Display time as time value; specify the type of
formatting desired by clicking an option in the Type list
box; right-align time in cell.
continues on next slide…
© Paradigm Publishing, Inc.
30
Format Numbers…continued
Click this category
To apply this number formatting
Percentage
Multiply cell value by 100 and display result with a
percent symbol; add decimal point followed by two
digits by default; number of digits can be changed with
the Decimal places option; right-align number in cell.
Fraction
Specify how fraction displays in cell by clicking an option
in the Type list box; right-align fraction in cell.
Scientific
Use for very large or very small numbers. Use the letter
E to tell Excel to move a decimal point a specified
number of positions.
Text
Treat number in cell as text; number is displayed in cell
exactly as typed.
Special
Choose a number type, such as Zip Code, Phone
Number, or Social Security Number in the Type option
list box; useful for tracking list and database values.
Custom
Specify a numbering type by choosing an option in the
Type list box.
© Paradigm Publishing, Inc.
31
Use the Format Cells Dialog Box
To align and indent data in
cells:
1. Make the desired cell
active or select the
desired cells.
2. Click the Alignment group
dialog box launcher in the
Home tab.
3. Select the desired
options in the Format
Cells dialog box at the
Alignment tab.
4. Click OK.
© Paradigm Publishing, Inc.
32
Alignment tab
Use the Format Cells Dialog Box…continued
To change the font:
1. Make the desired cell
active or select the
desired cells.
2. Click the Font group
dialog box launcher in
the Home tab.
3. Select the desired
options in the Format
Cells dialog box at the
Font tab.
4. Click OK.
© Paradigm Publishing, Inc.
Font tab
33
Use the Format Cells Dialog Box…continued
To add borders to cells:
1. Make the desired cell active
or select the desired cells.
2. Click the Borders button
arrow in the Font group in
the Home tab.
3. Click the More Borders
option at the drop-down
list.
4. Use the options in the
dialog box at the Border tab
to apply the desired border.
5. Click OK.
© Paradigm Publishing, Inc.
34
Border tab
Use the Format Cells Dialog Box…continued
To add shading to cells:
1. Make the desired cell active
or select the desired cells.
2. Click the Format button in
the Cells group in the Home
tab.
3. Click the Format Cells option
at the drop-down list.
4. Use the options in the
dialog box at the Fill tab to
apply the desired shading.
5. Click OK.
© Paradigm Publishing, Inc.
35
Fill tab
Format with Format Painter
To format with the Format
Painter:
1. Select the cell with the
desired formatting.
2. Click the Format Painter
button in the Clipboard
group in the Home tab.
3. Click the cell or selected
cells to which you want the
formatting applied.
© Paradigm Publishing, Inc.
36
Format Painter
button
Hide and Unhide Columns and/or Rows
To hide rows or columns:
1. Select the rows or
columns.
2. Click the Format button
in the Cells group in the
Home tab.
3. Point to the Hide &
Unhide option.
4. Click the Hide Rows or
Hide Columns option.
Format
button
© Paradigm Publishing, Inc.
37
Hide and Unhide Columns and/or Rows…continued
To unhide rows or columns:
1. Select the rows above
and below the hidden
row or the columns to
the left and the right of
the hidden column.
2. Click the Format button
in the Cells group in the
Home tab.
3. Point to the Hide &
Unhide option.
4. Click the Unhide Rows or
Unhide Columns option.
© Paradigm Publishing, Inc.
38
Hide & Unhide
option
1) You can apply a variety of
formatting with buttons in this
group in the Home tab.
a. Font
b. Editing
c. Formulas
Answer
d. Formatting
3) This is a set of formatting choices
that includes fonts, colors, and
effects.
a. texture
b. trial
c. trend
Answer
d. theme
2) When you select data this displays
in a dimmed fashion above the
selected data.
a. Format toolbar
b. Highlight bar
c. Mini toolbar
d. Font bar
Answer
4) When you click the Format
Painter button, the mouse pointer
displays with this attached.
a. paintbrush
b. white arrow
c. black arrow
d. crosshairs
Answer
Next Question
Next Question
Next Question
© Paradigm Publishing, Inc.
Next Slide
39
Formatting an Excel Worksheet
Summary of Presentation Concepts













Change column widths
Change row heights
Insert rows and columns in a worksheet
Delete cells, rows, and columns in a worksheet
Clear data in cells
Apply formatting to data in cells
Apply formatting to selected data using the Mini toolbar
Preview a worksheet
Apply a theme and customize the theme font and color
Format numbers
Repeat the last action
Automate formatting with Format Painter
Hide and unhide rows and columns
© Paradigm Publishing, Inc.
40