4 Ways to Fix Keyboard Function Keys not Working on Windows… Every computer has a set of keys that give quick access to specific actions.With them, it’s easy to navigate around the text. Top 5 Android Keyboards with Arrow Keys Almost all physical keyboards come with arrow keys.

Apart from just reducing the time and effort, they will make working with Excel a charm. I am sure these shortcuts will prove useful to you. Move to the cell in the lower-right corner Move to the cell in the upper-left corner Scroll Lock key will enable/disable this mode. By activating scroll lock you can navigate the window without losing cell selection. 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.

Excel page down shortcut