Wouldn’t it be nice if you could activate Excel 2007’s Formula bar without using the mouse? You can… try this!
Press the F2 key. This will let Excel know that you want to edit the contents of a cell. The first time you do this, Excel will probably expand the information in the cell and let you to edit the information inside that cell… but you can tell Excel you want F2 to open your formula bar by doing this:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- Click the Advanced option at the left of the dialog box.
- Make sure the Allow Editing Directly In Cell check box is cleared.
- Click on OK.
And that should do it… Now you should never have to take your hands off the keyboard while you’re putting together those worksheets!
