Choosing Editing Options
To control how Excel behaves when you're editing your worksheets, display the Edit preferences pane (see Figure 2–4) and choose options like this:
- Double-click allows editing directly in the cell. Select this check box if you want to be able to double-click a cell to open it up for editing. This is usually helpful—but if you clear this check box, double-clicking a cell makes Excel select the first cell referenced by the formula in that cell. This capability can be great when you're checking through formulas, so you need to decide which of the two double-click behaviors will be most helpful to you.
Figure 2–4. The ...