Excel 2000 Module 8
a large worksheet, the content of some rows or columns might
not fit on one screen. With Excel, you can locate using Go To
find the location of the cell :
and Shrinking a Worksheet on Screen
When you create a worksheet, Excel displays the cells and any
data they contain at a standard size, which Excel calls 100%.
magnify, or shrink a worksheet.
Each cell of the worksheet appears twice its original size.
Type 60 Click <OK>
Format Painter button allows you to copy formatting from a
cell or a range of cells and apply it to another cell or range
of cells. Note this is for one-time.
(Apply the Format)
Select Range (To
be Applied the Format)
The row labels now appear in red, bold, and 12-point Times New Roman
and Applying Styles
style can combine the following types of attributes (fromatting
Number, Alignment, Font,
Border, Patterns, Protection
You can modify and create the attributes of any of the styles.
Currently Normal style as the default
Click Style Name
Style Normal2 is created
button Click <Font>
New Roman> on the Font list
on the Style list
on the Size list Click <OK>
and Unhiding Rows and Columns
Sometimes you more rows or columns in a worksheet than you want
to see at one time. In such situations, you can hide rows
so that they don't appear on your screen or in your worksheet
D through L
Select Row 3
<Row> Click <Hide>
C and M
2 and 4
and Unfreezing Rows and Columns
If you want to see the other side of the worksheet and display
on the same screen, you can freeze rows and columns so that
they remain on the screen even when you scrool down and across
Workbooks via E-mail
You can have two options for sending a workbook via e-mail message
without leaving Excel, or you can send an Excel file as an attachment
to an e-mail message.
<File> <Send To>
Recipient (as Attachment)>
The e-mail message form appears.
Excel file is included as an attachment to the message.
2000 Final Project
Koh : We
completed on the New
Knowledge and Skills in
2000 Module 8.