ACCC Seminars

Welcome
Getting Started
Entering and Editing Data
Formulas and Functions
Formatting Cells
Page Setup and Print Preview
Charting
Related Links

Handout (PDF)
ACCC Seminars
Rev. Sep 15/2001

Getting Started in Excel 2000


 

Moving Around in Excel 2000

There are many ways to make a specific cell the active cell in Excel 2000. Most users click with their mouse on an active cell. However, since typing is a significant part of using Excel, there are keyboard shortcuts for moving around on a spreadsheet:

  • [UP ARROW] or [SHIFT] + [ENTER] Moves the active cell up one row
  • [DOWN ARROW] or [ENTER] Moves the active cell down one row
  • [LEFT ARROW] or [SHIFT] + [TAB] Moves the active cell one to the left
  • [RIGHT ARROW] or [TAB] Moves the active cell one to the right
  • [PAGE DOWN] Moves the active cell one screen down
  • [PAGE UP] Moves the active cell one screen up
  • [ALT] + [PAGE DOWN] Moves the active cell one screen right
  • [ALT] + [PAGE UP] Moves the active cell one screen left
  • [HOME] Moves the active cell to the first cell in the row
  • [END] Moves to the last active cell in a row
  • [CTRL] + [HOME] Moves to cell A1
  • [CTRL] + [END] Moves to the intersection of the last active row and column
  • [F5] or Click in the Name Box Allows user to enter a cell address and go directly to it

Back to TopExcel 2000 Intro Home Page The Excel 2000 Screen Selecting Cells Entering and Editing Data
   

Seminar materials:
<http://www.accc.uic.edu/seminars/excel2000-intro>

Last Modified: September 15, 2001 — pjm