• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Up, down, all around: Navigating in Excel

Get PDF file

by on
in Leaders & Managers,Management Training

Have you discovered all the shortcuts buried within Excel?

Try zipping around Excel spreadsheets using these keyboard techniques:

  • “Home” changes the “active cell” to the cell in column A of the current row.
  • “Ctrl”+“Home” makes cell A1 the active cell.
  • “Ctrl”+“End” changes the active cell to the cell farthest down and to the right of all the cells.
  • The right, left, up and down arrow keys advance your work sheet and your active cell one cell at a time.
  • “Page Up” and “Page Down” advance the work sheet and the active cell up and down, respectively, one screen at a time.
  • “Alt”+“Page Up” and “Alt”+ “Page Down” advance the work sheet and the active cell left and right, respectively, one screen at a time.
  • “Ctrl”+“Page Up” and “Ctrl”+ “Page Down” change the view to the next sheet and previous sheet, respectively.
  • “Ctrl”+arrow key (or “End” key followed by an arrow key) moves the cellpointer in the direction of the arrow pressed. The cellpointer goes to the first occupied cell if you start from a blank cell, or it goes to the last occupied cell if you start in an area where the cells are occupied.

—Adapted from "Excel Tip: Moving Around the Worksheet," www.accountingweb.com

Leave a Comment