Excel 2000 Module 8

Others (Optional)

  • Finding Cell Content
    In a large worksheet, the content of some rows or columns might not fit on one screen. With Excel, you can locate using Go To command.

    To find the location of the cell :
    <Edit> <Go To>
    Type AA100

    Select <F5> button
    Type A1

    Home <Ctrl><Home>


  • Managing 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%. You
    can magnify, or shrink a worksheet.

    any Cell
    Click <View> <Zoom>
    Click <200%> <OK>

    Each cell of the worksheet appears twice its original size.
    Click <View> <Zoom>
    Click <Custom> button
    Type 60 Click <OK>

    <View> <Zoom>
    Click <100%> <OK>

  • Using Format Painter
    The 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.

    Cell (Apply the Format)

    Select Range (To be Applied the Format)

    The row labels now appear in
    red, bold, and 12-point Times New Roman font.


  • Creating and Applying Styles
    A style can combine the following types of attributes (fromatting characteristics) :
    Number, Alignment, Font,
    Border, Patterns, Protection
    You can modify and create the attributes of any of the styles.

    Click <Format> <Style>
    Currently Normal style as the default
    Click Style Name box Type Normal2
    Style Normal2 is created

    Click <Modify> button Click <Font> tab
    Click <Times New Roman> on the Font list
    Click <Bold> on the Style list
    Click <14> on the Size list Click <OK>

    Select another Cell
    Click <Format> <Style>
    Click <Normal2> Click <OK>

  • Hiding 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 or columns so that they don't appear on your screen or in your worksheet printouts.

    Columns D through L
    Click <Format> <Column>
    Click <Hide>

    Select Row 3
    Click <Format> <Row> Click <Hide>

    Select Columns C and M
    Click <Format> <Column>
    Click <Unhide>

    Rows 2 and 4
    Click <Format> <Row>
    Click <Unhide>

  • Freezing 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 the worksheet.

Select Cell
Click <Window> <Freeze Panes>

Home <Ctrl> <Home>
<Window> <Unfreeze Panes>

  • Sending 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>
    Click <Mail Recipient (as Attachment)>
    The e-mail message form appears.

    The Excel file is included as an attachment to the message.

    <File> <Close>



Practice Final Project

Practice Excel 2000 Final Project


Practice Exercise (Optional)



Click <File> <Save>

Click <File> <Close>


Click <File> <Exit>




Edwin Koh : We completed on the New Knowledge and Skills in
Excel 2000 Module 8.






Previous Modules

1 : Introduction
2 : Excel Basic
3 : Formulas & Functions

4 : Formatting Spreadsheet

5 : Charts
6 : Printing
7 : Data Management



Edwin Koh InfoTech Learning