Jump to cell

  • Post author:
  • Post category:Uncategorized

While navigating through a large data set, we can scroll through the rows and columns to go to a specific cell.  However, this task becomes tedious and time-consuming when we have hundreds or even thousands of cells.

Fortunately, there are three methods to jump to cells in Excel.  This post will give us an overview of how to jump to cells using these methods:

  • Using the name box
  • Using keyboard shortcuts
  • Using Go To command

Jump to cells using name box

The name box is the box to the left of the formula bar that displays the cell reference of the active cell.  In below example, the active cell is D5 as shown in the name box.

Figure 1.  Name box in Excel

In order to go to a cell, we can directly enter a cell reference in the name box.  Let’s enter J7. Excel will instantly take us to cell J7 as shown below.  

Figure 2.  Output: Go to cell using name box

Go to cell keyboard shortcuts

In order to jump to the first cell and last cell in the worksheet, we make use of the keyboard shortcuts Ctrl + Home and Ctrl + End.  

Jump to first cell

In below example, the active cell is J10.   

Figure 3.  Sample data to jump to cell

We want to jump to the first cell which is A1. The quickest way to do that is to press Ctrl + Home.  This keyboard shortcut instantly takes us to A1.  

Figure 4.  Output: Jump to first cell

Note, however, that the result is slightly different when the Freeze Panes option is activated.  In below example, rows 1 and 2 and columns A and B are frozen. When we press Ctrl + Home, we will jump to C3, which is the first cell that is not in freeze mode.  

Figure 5.  Output: Using Ctrl + Home when in Freeze mode

Jump to last cell

When we press Ctrl + End, we are immediately taken to the last cell in our worksheet, AB33.

Figure 6.  Output: Jump to last cell

Using Go To command

Excel has a special feature called Go To, which can take us to any cell in the worksheet.  The Go To shortcut is F5 or Ctrl + G.  

The Go To dialog box will appear.  When we enter the cell reference in the text box for Reference, we will be taken directly to that cell.  For example, we want to go to cell A1.  

Figure 7.  Go To dialog box

We will be instantly taken to A1.  

Figure 8.  Output: Go To cell A1

Go To command has another unique feature.  When we press F5 again, Go To remembers the last cell prior to the current cell, which is W28.  

Figure 9.  Go To remembering last cell

We can click OK if we want to go back to cell W28, and we can also enter another cell reference, like Z32.  

When we are in Z32 and we press F5 again, the Go To text box will display the last two cells in the list.  In the Reference text box, the default cell is still the last cell visited prior to the current cell, A1.

Figure 10.  Go To displaying list of visited cells

We can also select a range by using the Go To command.  Enter the range B2:B10 in the reference and Go To will highlight the selected range.  

Figure 11.  Entering a range

Figure 12.  Output: Go To selecting a range

Go To Special

Go To has other features that we can navigate.  When we click the Special button, the Go To Special window will appear as shown below.  With Go To Special, we can customize the cells we want to select. We can choose only those with comments, those containing formula, or all blank cells.  

Figure 13.  Go To Special dialog box