Turn Off Editing Directly In Cell. Click Advanced from the left navigation menu in the dialog box. Click Options from the left navigation menu.
Does anyone have any idea. Now the Other Settings dialog box comes out please check the Allow in-cell editing option and click the OK buttons successively to close both dialog boxes. I usually have the Edit directly in cell option turned off because I always want to edit in the same place the formula bar.
See Figure 1 Clear the Edit Directly In Cell check box to turn off in-cell editing.
To stop working in Edit mode do one of the following. Click Options from the left navigation menu. The matter of another cell getting selected is probably caused by double-clicking too close to a cells edge. You can edit cells in Excel 2013 by selecting a cell and clicking inside the formula bar at the top of the window or you can double-click a cell and edit the data directly in the cell.
