By default, you can edit the data in a cell by using either the formula bar or by editing the data in the cell itself. To help protect your sheet, you can turn off the ability to edit data directly in the cell, which requires all changes to be made using the formula bar.
On the Excel menu, click Preferences.
Under Authoring, click Edit .
Clear the Double-click allows editing directly in the cell check box.