There are two easy ways to edit cell in a worksheet but before that...

Where do you want to do the editing in your worksheet cells? Excel allows you to specify if editing should be allowed only in the Formula bar or also in cells.

By default, Excel allows you to edit the cell information either in the Formula bar or in the cell itself. However, in some cases, you may want to turn the in-cell editing feature off because you want to protect your worksheet cells data being modify!

Here are the steps:

To edit the worksheet cells

Select the cell and press F2 key and start modifying
OR simply double-click on a cell that you wish to modify.

To turn off the cell editing

Click the Office ****on and then click Excel Options ****on.Advertisement

From the Excel Options dialog box displayed, click the Advanced at the left side of the dialog box.


Under the Editing options section, clear the Allow editing directly in cells check box.
Click on OK.