Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Activating the Formula Bar with the Keyboard

Summary: Hate to take your hands off the keyboard while working on a worksheet? Here's one way to activate the Formula Bar without the need of using the mouse. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

The Formula bar, just above the work area in Excel, shows the formula or value in the currently selected cell. You can click on the formula bar to edit information within a cell, if desired. What if you want to activate the Formula bar by using the keyboard, however?

The quickest way to do this is simply to press F2. This tells Excel that you want to edit the contents of a cell. When you press F2, it is highly possible that Excel will simply expand the information in the cell and allow you to edit the information directly in the cell itself. If you don't like this behavior, but instead want F2 to activate the Formula bar, follow these steps:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the Edit tab is selected. (Click here to see a related figure.)
  3. Clear the Edit Directly In Cell check box.
  4. Click on OK.

These steps won't work in Excel 2007. Follow these steps, instead:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. Click the Advanced option at the left of the dialog box. (Click here to see a related figure.)
  3. Make sure the Allow Editing Directly In Cell check box is cleared.
  4. Click on OK.

Now, whenever you press F2, the Formula bar is selected and you can edit the formula there.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2651) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.
 
Check out Top Fifteen Tips for Financing Christmas today!