And then, you may lose the focus from current cell. When you use the arrow keys or Page up/down keys to scroll, cell selection moves the distance you scroll.

Move to the next nonadjacent selected range to the left Move to the next nonadjacent selected range to the right Move clockwise to the next corner of the selected range To move from right to left within the selected range (or up if only one column is selected) Move from left to right within the selected range (or down if only one column is selected) Move from bottom to top within the selected range Move from top to bottom within the selected range Then, I realized they were meant to have overridden features. I accidentally discovered that some of those cell navigation keys work differently when a block of data is selected. To move between unlocked cells on a protected worksheet Move to the last unused cell in the bottom-most row Move to the edge of the current data region When you are working on one, you know how often you have to move from cell to cell and from one end to the other. And, that’s because Excel is all about data in cells. These are keys you will require almost always. Move to the next/previous worksheet pane in a worksheet that has been split Move to the previous sheet in the workbook And, to navigate to different workbooks we take help of the Windows taskbar. Most of us use the mouse to navigate to adjacent worksheets on a workbook. Tip: We have another super guide on all MS Excel shortcut keys that work with Function keys (F1 through F12) combination.

Key shortcuts for excel 2016