This also helps user to judge which part of the cell is selected and which is not.

Selecting any cell content once it is in edit mode, will highlight the cell content in grey color.Using F2 key for editing a cell is handy way to perform.Methods shown in the above examples are the best for making changes in any cell.Shortcut for editing the cell is the easiest way to change the cell content.Also, it will be reflecting in the same selected cell without seeing the blinking cursor on it. Whatever the changes that we do, will only be visible in the formula bar first. Which means that we can now only edit the cell content even after using a shortcut through Formula bar only. We will see, now the cursor is being only seen in the formula bar as show below. Now, go to the same cell C4 and press F2 key to go in edit mode of that cell.

Go to Advanced tab from the list of Excel Options as shown below.įrom the Editing Options section, uncheck the box of Allow editing directly in cells. For this, go to File menu ribbon and select Options from the list as shown below. We can make the changes in the default setting for editing any cell. We have done the same for the cell C4 here.įor selecting anything in edit mode, we can use the shortcut keys as SHIFT + Arrow (Right/Left) together. We cursor it at required position, then press F2 function key and select the content of that cell for testing purpose. To edit any cell using shortcut key, first put the cursor on the cell which we want to edit. For this, we will be using the same dataset as seen in example-1. F2 is one of the function key on all type of keyboards. In Excel, to edit any cell we have shortcut key as F2. There is another but the shortcut method to edit any cell. For example, if we want to edit cell A2, then using the mouse cursor, click double times on cell A2, and select the cell content Ashok for proof as shown below.Īs we can see the grey colored cells is the mark of selected cell content using the Edit cell process. On the Mac, this doesn't seem to work in certain areas, notably Define Names, and the New Formatting Rule window when adding a conditional format that uses a formula.Now if someone wants to go in edit mode in any of the cell from the above-shown table, then we can first try clicking double times on any cell which we want to edit. Pressing F2 / Ctrl+U repeatedly will cycle through modes.you'll see the mode displayed in the status bar, in the lower left corner. 'Edit' mode simply moves the cursor in the formula text. 'Point' and 'Enter' work similarly and allow you to point to a cell.

Once you are editing a cell, you can use the F2 / Ctrl+U again to toggle through available edit modes (edit, enter, point). If you want the cursor to move to the formula bar, see below. This shortcut enters cell edit mode with the cursor at the end of the last line of text in the cell.

Excel keyboard shortcut to edit cell