ExTools - Free Microsoft Excel add in ExTools - Free Microsoft Excel add in
Directory of useful FREE resources and software Home | About | Testimonials | Terms & Conditions | Contact | Sponsor
 
Download
 
Installation
 
Screenshots
 
User guide
 
Request features
--------------------------
Excel tips
--------------------------
Free Stuff
--------------------------
Donate
--------------------------
 
 

Home » Excel Tips » Worksheets » Navigating Excel Worksheet with Keyboard Keys

Navigating Excel Worksheet with Keyboard Keys

When you start to work with more data, your worksheet area will get larger and larger. It's not productive to simply press the arrow keys to navigate or scroll to the cell you want to edit. Fortunately, there's a simple method for the cell pointer to jump over empty cells and go to the next cell containing data.

By pressing Ctrl+Direction arrow keys (Ctrl+Up, Ctrl+Down, Ctrl+Left or Ctrl+Right), the cell pointer will jump over empty cells and land on the next cell with data. If the cell pointer is already on a cell with data, pressing Ctrl+Direction will cause the cell pointer to jump to the end cell of the range with data.

  1. Take a look at Figure 1. below. The cell pointer is at Cell A1. If you press Ctrl+Down, the cell pointer will jump to Cell A4(the cell containing 'a'). If you press Ctrl+Down again, the cell pointer will jump to Cell A11(the cell containing 'h'). Try Ctrl+Left and Ctrl+Right.

    Jump over empty cells of worksheet
    Figure 1. Jump over empty cells on worksheet
  2. If there is no more cell with data, the cell pointer will jump to the end of the row or column. (Row 65536 or Column IV)