Trick To Quickly Move Around Your Worksheets, Quickly Move your cursor position by Double-Click.
There is a very quick, easy and useful trick in Microsoft Excel about which most of the excel users don't know. You can move your cursor postion around your MS Excel Worksheet by Double-Click. You can select your data by this trick too.This feature has been available in Excel for many years, but most users have never discovered it.
To quickly jump to the end of a range of cells, double-click the edge of the currently selected range in the direction you want to move. When you double-click an edge of a cell, the active cell will jump in that direction to the last cell until it encounters a blank cell. (This works the same as holding down the CTRL key and pressing one of the arrow keys).
How to select data from the cursor position to the end around your worksheet by double click?
A similar trick can be used for selecting a range of cells or extending the current selection. Hold down the SHIFT key and double-click the edge of the currently selected range and the range will be expanded in that direction until it encounters a blank cell.
There is a very quick, easy and useful trick in Microsoft Excel about which most of the excel users don't know. You can move your cursor postion around your MS Excel Worksheet by Double-Click. You can select your data by this trick too.This feature has been available in Excel for many years, but most users have never discovered it.
To quickly jump to the end of a range of cells, double-click the edge of the currently selected range in the direction you want to move. When you double-click an edge of a cell, the active cell will jump in that direction to the last cell until it encounters a blank cell. (This works the same as holding down the CTRL key and pressing one of the arrow keys).
 |
| Double Click & Move |
How to select data from the cursor position to the end around your worksheet by double click?
A similar trick can be used for selecting a range of cells or extending the current selection. Hold down the SHIFT key and double-click the edge of the currently selected range and the range will be expanded in that direction until it encounters a blank cell.
 |
| Double Click & Select |
0 comments:
Post a Comment