Start Exploring Microsoft Excel 2003


Once the Microsoft Excel is launch, you can directly use it by entering data or you can choose to open the existing Excel file. Below are the step-by-step guides:

Creating and Opening Workbooks


To start using Microsoft Excel, you can start with a new blank workbook or open the existing Excel file.

To create a new default workbook

  • Click on the New icon located on the Standard toolbar
    OR press Ctrl+N


    To open a file

  • From the File menu, click Open.
  • From the Open dialog box as displayed, use the Look in: drop down menu to select the drive or folder that contains the file you want.
  • To open the file you can either double-click on the file name
    OR select the file name by clicking on it, and then click on the Open button.


    Microsoft Excel - Data Entry Techniques


    Here is the guide that shows the easy ways that you can use to enter data into the worksheet.

    To fill a range of cells with the same data

  • Highlight the cells you wish to fill.
  • Enter the information that you wish to fill the selected range with.
  • Press Ctrl+Shift+Enter and the range will be filled.


    To fill a range of cells with the 'automatic' data

  • Highlight the cells you wish to fill.
  • Enter the data into the cells as follow: A1: 1; A2: 2
  • Use the mouse to drag from cell A1 to A2.
  • Place your mouse in the bottom right corner of the selected cells until you see the “+” sign appear as follow:

    Fill range selection



  • Click and drag the mouse down the cells as you wish. You will see the selected range will fill with continuous numbers 3, 4, 5, 6,…
    Note: You also can replace the above A1 and A2 cells with days of week such as Monday, Tuesday,... and months like January, February,...


    Microsoft Excel - Navigating in the Worksheet


    How you can move from one place to another in Microsoft Excel? Here is the ways:

    To move to a particular cell (quick way)

  • Enter the cell that you wish to jump to into the Name Box (at the top, left of the screen). In the example shown the cell reference J50 has been entered. When you press the Enter key you will jump to the cell you entered.

    Name box




    To move from cell to cell using the keyboard

  • To move from cell to cell, use one of the following key or combination keys:
    IconFunction
    One cell to the right.
    One cell to the left.
    One cell down.
    One cell up.
    Ctrl + → To the right-hand edge of the current region.
    Ctrl + ← To the left-hand edge of the current region.
    Ctrl + ↓ To the bottom edge of the current region.
    Ctrl + ↑ To the top edge of the current region.
    Home To the first cell in the row.
    Ctrl + Home To the first cell in the worksheet.
    Ctrl + End To the lowest right-hand cell in the worksheet that contains a data entry.
    Page Down One screen down.
    Page Up One screen up.
    Alt + Page Down One screen to the right.
    Alt + Page Up One screen to the left.



    Microsoft Excel - Selection Techniques


    The selection techniques in Microsoft Excel allow you to select or highlight the cell(s) quickly so that you can perform the tasks such as deleting, copying, etc.

    To select a cell

  • Click on the cell you wish to select.


    To select a range of cells by dragging the mouse

  • Click on the first cell in the range.
  • Hold down the left-hand mouse button and drag over the cells you wish to include in the selection.


    To select a range of cells (making up a rectangular block)

  • Click on the first cell of the rectangular block that you wish to select (i.e. the left top-left hand corner)
  • Move down to the cell that marks the bottom-right corner of the rectangular block.
  • Depress the Shift key (and keep it depress).
  • Click once on the last cell of the required block and release the Shift key.


    To select a non-contiguous range

  • Select the first cell or range.
  • While holding down the Ctrl key, select the next range of cells.


    To select a row

  • Click on the row heading number.


    To select a column

  • Click on the column heading letter.


    To select an entire worksheet

  • Press Ctrl+A


    Microsoft Excel - Inserting and Deleting


    Microsoft Excel offers a convenient way for you to either insert or delete cell(s), column(s), row(s), or entire worksheet.

    To insert a row(s) into a worksheet

  • Select the row you want to move down when the new row is inserted above it.
  • To select more than one row, drag the mouse pointer across the required row headings.
  • Right-click on the selected row(s) to display a pop-up menu.
  • Select Insert. Any existing data will move down to accommodate the new cells.

    Insert pop-up



    To insert column(s) into a worksheet

  • Select the column you want to move to the right when the new column is inserted.
  • To select more than one column, drag the mouse pointer across the required column headings.
  • Right-click on the selected column(s) to display a pop-up menu.
  • Select Insert. Any existing data will move down to accommodate the new cells.


    To delete a row or column

  • Use the same techniques outlined above, but select the Delete command from the pop-up menu.


    To insert cells or range of cells

  • Select the cell where you want to insert a new cell.
  • From the Insert menu, click Cells.
  • From the Insert dialog box, select one of the following options:

    Entire column Moves all cells in the column to the right and inserts a new column.
    Entire row Moves all cells in the row down and inserts a new row.
    Shift cells down Moves existing cells down and inserts one cell.
    Shift cells right Moves existing cells to the right and inserts one cell.

  • Click on the OK.


    To delete cells or ranges of cells

  • Select the cell(s) you want to delete.
  • From the Edit menu, click Delete.
  • From the Delete dialog box displayed, select one of the options.
  • Click on the OK button.


    To insert a worksheet

  • Click the sheet tab to select the worksheet where you want to insert a new one. The new worksheet will be inserted before this worksheet.
  • From the Insert menu, click Worksheet.


    To delete a worksheet

  • Click on the sheet tab to select the worksheet you wish to delete.
  • From the Edit menu, click Delete Sheet.
  • Select OK to permanently delete the selected sheet.


    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    >> Next Topic : Mystery Concept behind the Copy and Paste

    << Previous Topic : Getting Started with Microsoft Office Excel


    You're viewing the Microsoft Excel 2003 Tutorial info page, click here to go back to the Home Page