Controlling Where You Edit Cell Contents

By default, Excel allows you to edit cell information either in the Formula bar or in the cell itself. (Select the cell and press F2, or simply double-click on a cell.) You may want to turn the in-cell editing feature off, however. To do this, you can follow these steps:

  1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel 2013 display the File tab of the ribbon and then click Options.)
  2. Click Advanced at the left side of the dialog box. (See Figure 1.)
  3. Figure 1. The Advanced options of the Excel Options dialog box.

  4. In the Editing Options section, clear the Allow Editing Directly in Cells check box.
  5. Click on OK.