O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.
    images

    Figure 2–4. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required