how to enable editing in excel 2010 for formula bar

Here we introduce the Enhanced Edit Bar feature of Kutools for Excel. Edit a long content cell easily with an awesome feature Press Alt + Q keys simultaneously to close the Microsoft Visual Basic for Applications window.įrom now on, when selecting a cell or pressing the Enter key to move to the next cell in this worksheet, it will get into the editing mode automatically. VBA code: type in or edit cell without double clicking itģ. Then copy and paste the below VBA code into the window. In the Microsoft Visual Basic for Applications window, please double click the sheet name (cells you need to edit locating in this worksheet) in the left bar to open the code window. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.Ģ. If pressing F2 key is also time-consuming for you, you can try the following VBA method.ġ. The Enhanced Edit Bar utility of Kutools for Excel can help you easily view and edit a long content cell without double clicking the cell or enlarging the Formula Bar.ĭownload and try it now! ( 30-day free trail) View and edit a long content cell easily in Excel: Note: You need to press the F2 key repeatedly for editing all cells in a list. It is easy to operate, you just need to select the cell you want to edit and press the F2 key, and the cursor will be located at the end of the cell value, then you can edit the cell immediately. You can press the F2 key to get into the editing mode of a cell without double clicking it. Type in or edit cell with pressing the F2 key This tutorial introduces three methods, which can help to edit cell easily in Excel.

For editing a cell with long content that exceeds the cell size, you need to get into the editing mode, and then find the accurate position to make the change. Usually, when editing a cell with content, you need to double click it to get into the editing mode at first. How to type in or edit cell without double clicking it in Excel?

How to enable editing in excel 2010 for formula bar