Do you know that we can move from the cells containing data to the next cells by using shortcut key?
Sometimes we have filed data into cells of worksheet. However, not every cell we do put data inside it.
Therefore, there are some cells might be empty. I have heralded the empty cells because it is significant for the shortcut key as we are going to explore it today.
The shortcut key to move to the edge of the next region cells, which they have the data entered. Those the key buttons are [Ctrl] + [Arrow Keys].
Method:
This shortcut helps you to navigate any cells quickly, which they have the data entering within inside. The empty cells will be skipped.
Notice:
Remember that the [Ctrl] key is the main button, to begin from it first, then just choose one of the four [Arrow Keys] set, Left; Right; Upper and Lower Arrow.
Sometimes we have filed data into cells of worksheet. However, not every cell we do put data inside it.
Therefore, there are some cells might be empty. I have heralded the empty cells because it is significant for the shortcut key as we are going to explore it today.
The shortcut key to move to the edge of the next region cells, which they have the data entered. Those the key buttons are [Ctrl] + [Arrow Keys].
Method:
- Press the [Ctrl] key button and hold down
- To push the [Arrow Keys] button down while keeping the ‘Ctrl’ key in freezing
- Keep pressing the ‘Arrow Keys’ to some cells as you needed
- Release the 2 keys
This shortcut helps you to navigate any cells quickly, which they have the data entering within inside. The empty cells will be skipped.
Notice:
Remember that the [Ctrl] key is the main button, to begin from it first, then just choose one of the four [Arrow Keys] set, Left; Right; Upper and Lower Arrow.
Function Key
|
Result Description
|
---|---|
Ctrl + Arrow Left
| Move to the edge of the next left region cells data entering |
Ctrl + Arrow Right
| Move to the edge of the next right region cells data entering |
Ctrl + Arrow Up
| Move to the edge of the next upper region cells data entering |
Ctrl + Arrow Down
| Move to the edge of the next lower region cells data entering |
See more shortcut:
- [Tab] Move One Cell To The Right / [Shift+Tab] Move To The Left-Excel
- Fill Out Respective Data 2 Cells Intervening by Non-Adjacent Cells Each
- Tricks Adding Number, Date, Letter, Etc. Excel Column with Double Click
- Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally
- Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard
You might like my another blogs:
Comments
Post a Comment