4.0 - Worksheet formatting-1.pptx - Last week Name ranges...

Last week
 Name ranges
 Name box (tables)
 Define name
 Create from selection (name of the range in an adjacent cell)
 Insert Name Ranges in formulas and functions
 COUNTA() Function
 COUNTBLANK() Function
 ROUND() Function
Slide 1 of 22

To count the number of cells containing Text in a
selected range

You would use
A.
The COUNT() Function
B. The SUM() Function
C. The COUNTA() Function
D. A & C would both work

To add the numbers contained a selected range

You would use

PRINTING
4

Printing
Setting the print area
1.
Select the range to be printed
2.
Under the “Page Layout” tab,
click on the “Print Area” drop-
down menu
3.
Click on “Set Print Area”
Slide 5 of 22

Printing
Setting the print area
 You can define multiple and separate print areas
 They will print on different documents
Mouse
1.
Select a range with the mouse
2.
Hold the Ctrl key
3.
Select another range
4.
Set the “Print area”
Keyboard
5.
Select a range
6.
Press Shift F8 to anchor the first area
7.
Select a second range
8.
Press Shift F8
9.
Repeat as needed
10.
Set the “Print area”
You can verify your print areas by pressing the F5 key (GoTo) and
selecting Print_Area
Slide 6 of 22

Printing
 Pre-viewing and adjusting the
document
 The Print menu is activated
by clicking on the File tab
 Or Ctrl F2 on the keyboard
 The Print page displays
⁻
a preview of the printed document
⁻
page formatting commands
(size, scaling, orientation, margins…)
⁻
A drop-down menu listing available
printer
⁻
the Print button to launch the actual
printing
Slide 7 of 22

4 - Worksheet: Formatting & Copying
HM 271
8

Objectives
 Format text, numbers, and dates
 Change font colors and fill colors
 Use the format painter
 Merge a range into a single cell
 Apply a built-in cell style

Select a different theme
 Format multiple worksheets a time
 Apply a built-in table style
 Add conditional formats to tables with highlight rules and data bars
 Hide worksheet rows & columns
Slide 9 of 22

Formatting
 Formatting is the process of changing a workbook’s appearance by defining the
fonts, styles, colors, and appearance features
 A theme is a collection of formatting that specifies the fonts, colors, and graphical
effects used throughout the workbook
 The quality of your work is evaluated based on both substance and appearance .