- column
- TECHNOLOGY Q&A
Accelerate editing of complex formulas in Excel
Please note: This item is from our archives and was published in 2008. It is provided for historical reference. The content may be out of date and links may no longer function.
Related
Incorporating prompt engineering into the accounting curriculum
Create a dynamic to-do list with Excel’s checkboxes
Another way to manage authentication texts
TOPICS
![]()
Yes, you can program the F2 button to give you immediate access to the formula in the Formula bar so you can immediately edit the formula there… …rather than in the crowded space of the cell. To do that in Excel 2003, click on Tools , Options and the Edit tab. Then remove the check next to Edit directly in cell , and then click on OK .
Advertisement
In Excel 2007, access the F2 default switch by clicking on the Office Button and then on Excel Options at the bottom of the screen (see screenshots below). And finally remove the check next to Allow editing directly in cells (see screenshot at left).
| ||