![]() ![]() When we press Ctrl + Home, we will jump to C3, which is the first cell that is not in freeze mode.įigure 5. In below example, rows 1 and 2 and columns A and B are frozen. Note, however, that the result is slightly different when the Freeze Panes option is activated. This keyboard shortcut instantly takes us to A1. The quickest way to do that is to press Ctrl + Home. We want to jump to the first cell which is A1. In below example, the active cell is J10. 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. ![]() Output: Go to cell using name box Go to cell keyboard shortcuts Excel will instantly take us to cell J7 as shown below.įigure 2. In order to go to a cell, we can directly enter a cell reference in the name box. In below example, the active cell is D5 as shown in the name box. The name box is the box to the left of the formula bar that displays the cell reference of the active cell. This post will give us an overview of how to jump to cells using these methods: However, this task becomes tedious and time-consuming when we have hundreds or even thousands of cells.įortunately, there are three methods to jump to cells in Excel. While navigating through a large data set, we can scroll through the rows and columns to go to a specific cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |