One of the blogs I usually visit is excel Bacon Bits . Reading your article of May 10 I discovered a new trick I know: the ability to move in a range by double clicks on the edges of the selected cell. Let's take a simple example. Suppose we have the following table:
We in cell B4. If you double-click the bottom edge of the selected cell excel moves us to the last cell with content below the cell that is:
The same can be done right, left or up, by double clicking the right edge, left or top respectively.
this trick we can "get a little more juice" if you press the Shift while we make the double click. In this way select areas on the right, left, up or down quickly.
0 comments:
Post a Comment