Transcript Chapter 3

© Paradigm Publishing, Inc.
1
Excel 2013
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 Rows
 CHECKPOINT 2
Change Column Width
column boundary
To change column width:
1. Drag column
boundary line.
OR
1. Double-click column
boundary.
OR
1. Click Format button.
2. Click Column Width at
drop-down list.
3. Type desired width.
4. Click OK.
© Paradigm Publishing, Inc.
4
Change Column Width - continued
To change column width of
selected adjacent columns:
1. Select desired columns.
2. Drag one column
boundary 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 Format button.
2. Click Column Width
option at drop-down list.
3. Type desired width.
4. Click OK.
© Paradigm Publishing, Inc.
6
Column Width
dialog box
Change Row Height
To change row height:
1. Drag row boundary.
OR
1. Click Format button.
2. Click Row Height at
drop-down list.
3. Type desired height.
4. Click OK.
© Paradigm Publishing, Inc.
row boundary
7
Change Row Height - continued
To change row height of
selected adjacent rows:
1. Select desired rows.
2. Drag one row boundary
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 Format button.
2. Click Row Height option
at drop-down list.
3. Type desired height.
4. Click OK.
© Paradigm Publishing, Inc.
Row Height
dialog box
9
Insert Rows
To insert a row with the Insert
button:
1. Click Insert button.
Insert button
© Paradigm Publishing, Inc.
10
Insert Rows - continued
To insert a row with the
Insert Sheet Rows option:
1. Click Insert button arrow.
2. Click Insert Sheet Rows at
drop-down list.
Insert Sheet
Rows option
© Paradigm Publishing, Inc.
11
Insert Rows - continued
To insert a row at the Insert
dialog box:
1. Click Insert button arrow.
2. Click Insert Cells option.
3. Click Entire row option in
Insert dialog box.
4. Click OK.
© Paradigm Publishing, Inc.
12
Insert dialog box
Insert Columns
To insert a column with the
Insert Sheet Columns
option:
1. Click Insert button
arrow.
2. Click Insert Sheet
Columns at drop-down
list.
Insert Sheet
Columns option
© Paradigm Publishing, Inc.
13
Insert Columns - continued
To insert a column at the
Insert dialog box:
1. Click Insert button
arrow.
2. Click Insert Cells.
3. Click Entire column.
4. Click OK.
Entire column option
© Paradigm Publishing, Inc.
14
Delete Cells, Rows, or Columns
To delete a cell:
1. Make cell active.
2. Click Delete button arrow.
3. Click Delete Cells option at
drop-down list.
4. At Delete dialog box, specify
what to delete.
5. Click OK.
© Paradigm Publishing, Inc.
15
Delete dialog box
Clear Data in Cells
To clear data in cells:
1. Select desired cells.
2. Press Delete key.
OR
1. Select desired cells
2. Click Clear button.
3. Click Clear Contents at
drop-down list.
© Paradigm Publishing, Inc.
Clear Contents option
16
1) To display the Column Width
dialog box, click the Format
button on 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 on the
HOME tab.
Font group
© Paradigm Publishing, Inc.
18
Apply Formatting - continued
To change the font:
1. Make desired cell
active or select the
desired cells.
2. Click Font button
arrow.
3. Scroll down drop-down
gallery and click
desired font.
© Paradigm Publishing, Inc.
Font button arrow
19
Apply Formatting - continued
To add a border:
1. Make desired cell active
or select desired cells.
2. Click Borders button
arrow.
3. Click desired option at
drop-down list.
© Paradigm Publishing, Inc.
Borders button arrow
20
Apply Formatting - continued
To apply fill color:
1. Make desired cell active or select desired cells.
2. Click Fill Color button arrow.
3. Click desired color option.
Fill Color
button arrow
© Paradigm Publishing, Inc.
21
Apply Formatting - continued
To change the font color:
1. Make desired cell active or
select desired cells.
2. Click Font Color button
arrow in Font group on
HOME tab.
3. Click desired color at dropdown color palette.
© Paradigm Publishing, Inc.
22
Font Color
button arrow
Apply Formatting - continued
 Double-click in a cell and then select data within the
cell and the Mini toolbar displays 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 desired cells.
2. Click Merge & Center
button arrow.
3. Click Merge Across
option at drop-down list.
Merge Across option
© Paradigm Publishing, Inc.
25
Apply Formatting - continued
To rotate text:
1. Make desired cell active
or select desired cells.
2. Click Orientation button
in Alignment group on
HOME tab.
3. Click desired option at
drop-down list.
© Paradigm Publishing, Inc.
Orientation button
26
Apply a Theme
To apply a theme:
1. Click PAGE LAYOUT tab.
2. Click Themes button.
3. Click desired theme at dropdown gallery.
Themes button
© Paradigm Publishing, Inc.
27
Format Numbers
To format numbers
using the Number
Format button:
Number Format
button arrow
1. Make desired cell
active or select
desired cells.
2. Click Number Format
button arrow.
3. Click desired number
format at drop-down
list.
© Paradigm Publishing, Inc.
28
Format Numbers - continued
To format numbers using the
Format Cells dialog box:
1. Make desired cell active or
select desired cells.
2. Click Number group dialog
box.
3. Click desired number format
in Format Cells dialog box
with Number tab selected.
4. Click OK.
© Paradigm Publishing, Inc.
29
Number tab
Format Numbers - continued
Click this category
To apply this number formatting
Number
Specify the number of places after the decimal point and
whether a thousand separator should be used; choose the
display of negative numbers; right-align numbers in the cell.
Currency
Apply general monetary values; add a dollar sign as well as
commas and decimal points, if needed; right-align numbers in
the cell.
Accounting
Line up the currency symbols and decimal points in a column;
add a dollar sign and two places after the decimal point; rightalign numbers in the cell.
Date
Display the date as a date value; specify the type of formatting
desired by clicking an option in the Type list box; right-align
the date in the cell.
Time
Display the time as a time value; specify the type of formatting
desired by clicking an option in the Type list box; right-align
the time in the cell.
continues on next slide…
© Paradigm Publishing, Inc.
30
Format Numbers - continued
Click this category
To apply this number formatting
Percentage
Multiply the cell value by 100 and display the result with a
percent symbol; add a decimal point followed by two places
by default; change the number of digits with the Decimal
places option; right-align numbers in the cell.
Fraction
Specify how a fraction displays in the cell by clicking an option
in the Type list box; right-align a fraction in the cell.
Scientific
Use for very large or very small numbers; use the letter E to
tell Excel to move the decimal point a specified number of
places.
Text
Treat a number in the cell as text; the number is displayed in
the 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 desired cell active or
select desired cells.
2. Click Alignment group dialog
box.
3. Select desired options in
Format Cells dialog box with
Alignment tab selected.
4. Click OK.
© Paradigm Publishing, Inc.
32
Alignment tab
Use the Format Cells Dialog Box - continued
Font tab
To change the font:
1. Make desired cell
active or select desired
cells.
2. Click Font group dialog
box.
3. Select desired options
in Format Cells dialog
box with Font tab
selected.
4. Click OK.
© Paradigm Publishing, Inc.
33
Use the Format Cells Dialog Box - continued
To add borders to cells:
1. Select cells.
2. Click Borders button arrow.
3. Click desired border.
OR
1. Select Cells
2. Click Borders button arrow.
3. Click More Borders.
4. Use options in dialog box to
apply desired border.
5. Click OK.
© Paradigm Publishing, Inc.
34
Border tab
Use the Format Cells Dialog Box - continued
To add fill and shading to cells:
1. Select cells.
2. Click Fill Color button arrow.
3. Click desired color.
OR
1. Select cells.
2. Click Format button.
3. Click Format Cells at drop-down list.
4. Click Fill tab.
5. Use options in dialog box to apply
desired shading.
6. Click OK.
© Paradigm Publishing, Inc.
35
Fill tab
Format with Format Painter
To format with the Format
Painter:
1. Select cells with desired
formatting.
2. Double-click Format Painter
button.
3. Select desired cells.
4. Click Format Painter button.
© Paradigm Publishing, Inc.
36
Format Painter button
Hide and Unhide Columns and/or Rows
To hide rows or columns:
1. Select rows or columns.
2. Click Format button.
3. Point to Hide & Unhide.
4. Click Hide Rows or Hide
Columns.
© Paradigm Publishing, Inc.
Format button
37
Hide and Unhide Columns and/or Rows - continued
To unhide rows or columns:
1. Select rows above and
below hidden row or
columns to left and right
of hidden column.
2. Click Format button.
3. Point to Hide & Unhide
option.
4. Click Unhide Rows or
Unhide Columns option.
Hide & Unhide option
© Paradigm Publishing, Inc.
38
1) You can apply a variety of
formatting with buttons in this
group on 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
above the selected data.
a. Format toolbar
b. Highlight bar
c. Mini toolbar
d. Font bar
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
Answer
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