How to use Excel : Excel Basics – Keyboard shortcuts to move around the cells in Excel


Introduction

We have studied about the different methods of navigating between the excel cells and we concisely mentioned about the keyboard shortcuts that can be used to navigate between cells. Here we list all the important keyboard shortcuts that can be used for navigation in different scenarios.

Excel has made navigating within the cells of the worksheet super easy for its users. With the correct combination of various keystrokes one can easily scroll the worksheet view automatically to the desired location.

Simple keyboard shortcuts for Navigation in Excel

Here are the keystrokes and keyboard shortcuts that will make your life easier as an Excel user and will surely make you look like an expert.

Keystroke                -            Cursor movement

→                                           Move to Cell which is at the immediate right of the current cell.

 Tab                                       Move to Cell which is at the immediate right of the current cell.

←                                           Move to Cell which is at the immediate left of the current cell.

Shift+Tab                             Move to Cell which is at the immediate left of the current cell.

↑                                           Move to Cell which is one row up to the current cell.

↓                                           Move to Cell which is one row down to the current cell.

Home                                    Move to Cell which is in column A of the current row.

PgUp                                     Move to Cell which one screenful up in the same column of the current cell.

PgDn                                     Move to Cell which one screenful down in the same column of the current cell.

 

Navigation Keyboard shortcuts using the Ctrl Key

To use these shortcut combinations just hold down the Ctrl key and then press the other key in the combination i.e. both the keys will be pressed together. This is symbolized by the ‘+’ sign.

Ctrl + Home                        Move to the first cell of the worksheet i.e. the cell A1

Ctrl + End                             Move to the last cell of the active area of the worksheet i.e. last cell of that area of the worksheet that has some data.

Ctrl + →                                Move to the first occupied cell to the right of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very end of the row.

Ctrl + ←                                Move to the first occupied cell to the left of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very beginning of the row.

Ctrl + ↑                                Move to the first occupied cell above the current cell. If there is no such occupied cell, the pointer goes to the cell at the top of the column.

Ctrl + ↓                                Move to the first occupied cell below the current cell. If there is no such occupied cell, the pointer goes to the cell at the bottom of the column.

Ctrl + Page Down              Move to the last occupied cell in the next worksheet of that workbook.

Ctrl + Page Up                    Move to the last occupied cell in the previous worksheet of that workbook.

 

 

Navigation Keyboard shortcuts using the End Key

To use these shortcut combinations press the END key, release it and then press the other key in the combination i.e. both the keys will be pressed one after another. This is symbolized by the ‘~’ sign.

Note # When we press the End key Excel enters the END MODE which is indicated on the status bar and it shows that Excel is waiting for another keystroke.

End ~ Home                        Move to the last cell of the active area of the worksheet i.e. last cell of that area of the worksheet that has some data.

End ~  →                              Move to the first occupied cell to the right of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very end of the row.

End ~ ←                               Move to the first occupied cell to the left of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very beginning of the row.row.

End ~ ↑                               Move to the first occupied cell above the current cell. If there is no such occupied cell, the pointer goes to the cell at the top of the column.

End ~ ↓                               Move to the first occupied cell below the current cell. If there is no such occupied cell, the pointer goes to the cell at the bottom of the column..

Note # Use the scroll lock button on your keyboard to navigate within the worksheet area without changing the current cell position. That is we can navigate to different area on the worksheet through our keyboard but the current cell does not change. In other words the keyboard navigation works in the same as scrollbar navigation.

 

Conclusion

It is advised that users should go through all these keyboard shortcuts and practice them again and agian untill these shortcuts become a part of your habit. This is very important for working swiftly with excel. These shortcuts will save a lot of your time and energy and straightaway increase your productivity manifolds.