Chapter Two: Data and Cells


Lesson 1: Moving around the Worksheet

In entering data, you must first select the cell. The default location of the cursor upon opening MS Excel is cell A1 which is referred to as the cell address. The cell address is the combination of column heading and the row number. As the cursor is moved, the Name Box displays the new active cell. To move around the worksheet, you can use either the keyboard or the mouse.

Use the keyboard shortcuts to move to a desired cell.

Keyboard Shortcuts

To move right (one cell)

Press right arrow key () or Tab

To move left (one cell)

Press left arrow key () or Tab

To move down (one cell)

Press arrow down ()

To move up (one cell)

Press arrow up ()

To a specific cell

Press F5 then type the cell address

To the beginning of a row

Home

To the end of a row

End and arrow right or Ctrl+arrow right

To the beginning of a spreadsheet

CTRL+Home

To the end of a spreadsheet

CTRL+End

You can immediately know the address of the cell by looking at the Name Box; it displays the cell address or the location of the active cell in the active sheet as shown below.

click to expand

click to expand

Use the mouse to move around the worksheet.

  • To select a single cell, point to the desired cell (your mouse pointer changes to a thick cross) then click the cell.

The different forms of Mouse Pointer in the spreadsheet.

Arrow - used to select a command from the menu bar or toolbars.

Thick Cross - used to select a cell or range of cells.

I-beam - used to edit text within a formula bar. This pointer appears when your mouse pointer rests on the Name Box and Font Box.

Fill Handle - used to copy cell content.

Double Arrow - allows you to adjust the column width by dragging it to the left and right and the row height by dragging it up and down.

Whiz Words

start example

Name Box

Ctrl+Home

Active Cell

Ctrl+End

F5

Fill Handle

end example

Lesson Summary

There are different ways to move around in the worksheet, mouse, keyboard stroke, or the feature of MS Excel for navigating through the worksheet. The cell indicator determines the location of the active cell. You can also determine the exact location of the active cell by simply looking in the Name Box.

Study Help

start example

Directions: Identify the following.

  • _______________1. It is used to copy cell content.

  • _______________2. The keyboard shortcut if you want to go the end of the spreadsheet.

  • _______________3. The default active cell upon opening MS Excel.

  • _______________4. To go to a specific cell.

  • _______________5. It is used to select a command from the menu bar or toolbars.

  • _______________6. The keyboard shortcut if you want to go to the beginning of the worksheet.

  • _______________7. It is use to select cells or range of cells.

  • _______________8. The key to be pressed if you want to go to the beginning of a row.

  • _______________9. The key to be pressed if you want to go to the end of a row.

  • _______________10. The key to be pressed if you want to move one cell.

end example

start sidebar
Exercise

Directions: Follow the instructions carefully.

  1. Open MS Excel.

  2. Move the active cell indicator to cell G5 using the arrow keys.

  3. Click the mouse pointer to D7.

  4. Press F5 to move the active cell indicator to X25.

  5. Perform the following shortcut keys and observe where the active cell indicator will be placed.

    1. CTRL+Home

    2. CTRL+Dow Arrow Key

    3. CTRL+Right Arrow Key

  6. Press F5 to move the active cell indicator to cell A1.

end sidebar




Microsoft Excel Whiz 2002 2003
Microsoft Excel Whiz 2002 2003
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 66

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net