Double-click trick for navigating within worksheets

Let’s say that you want to edit the contents of a worksheet cell. Many of us reflexively double-click on the cell in question and get to work. Folks that are into keyboard shortcuts often press F2 (Fn + F2 on certain keyboards) instead of double-clicking. Or you might select a cell and then click into the Formula Bar. All three are valid, but a slight variation on the first approach may make you think Excel is possessed. Allow me walk you through a scenario:

1. Activate the Double-Click Navigation worksheet, as shown in Figure 9.6:

Figure 9.6 – A four-pointed arrow indicates the navigation mode

2. Position your mouse over the middle of cell B4 and notice how your cursor presents as a white cross, and then click once to select cell B4.
3. Position your mouse over the bottom border of cell B4 and notice how your cursor changes to a four-pointed arrow, as shown in Figure 9.6. Now, here...