Excel Tip: Moving around the worksheet

There are several techniques for moving from one place to another on an Excel worksheet. Here are some of the most common techniques:

Using the mouse:

  • Use the mouse to click in any visible cell. That cell becomes the active cell - the cell in which your data will appear when you begin typing.

  • Click on the arrows at the ends of either scroll bar to advance the worksheet one cell at a time in the chosen direction.

  • Click in the open area on either side of the box that appears in the scroll bar to advance the worksheet one screen at a time in the chosen direction.

  • Drag the box that appears in the scroll bar to slide the worksheet in the chosen direction.

  • Click on the Sheet tabs at the bottom of the screen to change from one sheet to another.

    Using the keyboard:

  • The RIGHT, LEFT, UP, and DOWN ARROW keys on the keyboard advance your worksheet and your active cell one cell at a time in the chosen direction.

  • 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 that is the farthest down and to the right of all the cells that have been used in your worksheet.

  • PAGE UP and PAGE DOWN advance the worksheet and the active cell up and down, respectively, one screen at a time.

  • ALT+PAGE UP and ALT+PAGE DOWN advance the worksheet 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 are starting from a blank cell, or it goes to the last occupied cell if you are starting in an area where the cells are occupied.

  • To advance to a particular cell, press the F5 function key, enter the cell reference (e.g. G24), and press ENTER.

    You may like these other stories...

    Cybersecurity is no longer the domain of an organization's IT staff. It's moved to the boardroom, and in a big way. Accountants and financial managers may have been thinking it's just the province of the tech...
    You probably don't want to think about how many times you access the File menu in Excel 2010 or 2013. Personally I think Excel 2010 has the best possible File menu arrangement, other than having Print Preview grafted...
    Following other recent high-profile hacking events, investigators discovered yesterday that hackers broke into the draft work paper files of several famous CPA firms. Revealing images of the scantily clad documents have been...

    Already a member? log in here.

    Upcoming CPE Webinars

    Sep 24
    In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
    Sep 30
    This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
    Oct 21
    Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience's communication style.
    Oct 23
    Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.