Disable or Enable direct Editing in cells in Excel 2010

By default, the Excel application will allow you to directly edit the data present inside the cells in a Worksheet. i.e., you can easily edit the data present inside the cells by double clicking inside that particular cell. However, if you do not want direct editing inside the cells, then you can make the excel application disable this feature. Below is a tutorial that will guide on how to disable this feature in Excel 2010 Application.

1) Click on the “File” tab and then on ‘Options’ tab.

Figure 1

2) In “Excel Options” window, click on the ‘Advanced’ tab.

Figure 2

3) Under the ‘Advanced’ tab, in the ‘Editing Options’ category, clear the check box that says ‘Allow editing directly in cells’ and click on the ‘OK’ button.

Figure 3

4) To enable direct editing, select the check box mentioned in the above step and click on the ‘OK’ button.

So, this tip comes in very handy, if you are in a situation, where you are not able to edit the contents of a cell directly and every time you want to edit the contents, you have to delete the contents of the whole cell and retype the contents once again.

Read Other Applications