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.
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.
Figure 1. Jump over empty cells on worksheet
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)