Microsoft Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 training 
 Home Products Programs Meet Dawn Free E-zine Media Room Contact
Tip: Go To Formula Bar  

Technology Trainer
Software & Tech Speaker
Software Consultant
Tips & Tricks
The Pro Shop
Free Software Articles
How-To Lessons
Tips Newsletter
Bonus Resources

 
Dawn Bjork Buzbee
The Software Pro
®

Microsoft Certified Trainer (MCT)

Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor

Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor

Microsoft Certified Application Specialist (MCAS) Instructor

Certified Microsoft Office Expert

Certified Women's Business Enterprise (WBE)

(303) 699-6868
Dawn@SoftwarePro.com


Microsoft Excel Tip

Category: Excel Editing
Versions: All versions of Microsoft Excel

>>More Microsoft Excel 2010 Tips & Tricks
>>More Microsoft Excel 2007 Tips & Tricks
>>More Microsoft Excel 2003 (and earlier) Tips & Tricks

Keyboard Shortcut to Go To Formula Bar
To enter formulas in an Excel worksheet, just select a cell and start typing. To edit an existing formula, you probably make changes in the Formula bar (above the column headings) which you can access with a click of the mouse. That method’s fine but some people (like me) prefer working with the keyboard as much as possible. If that describes you, press the [F2] function key instead of reaching for the mouse the next time you want to edit an existing formula.

>>Excel Shortcuts for Editing a Cell

When you use [F2] to edit a cell, by default, [F2] positions the cursor in the cell (for "in place editing") instead of the Formula bar. To change the [F2] function key so it moves directly to the Formula bar:

Excel 2003 (and earlier):

  • From the Tools menu, choose Options.
  • Pick the Edit tab.
  • Uncheck the Edit Directly In Cell option in the Settings area. OK to apply.

Excel 2007:

  • Click the Office button and then pick Excel Options (at the bottom right).
  • Select Advanced in the left pane.
  • Uncheck the Allow editing directly in cell option. OK to apply.

Excel 2010:

  • Click the File tab and then pick Options (at the left).
  • Select Advanced in the left pane.
  • Uncheck the Allow editing directly in cell option. OK to apply.

>>More Tips & Tricks


Be an Excel Expert!
How effectively are you using Excel to create, format, and analyze your important data? Become an Excel expert with the
Excel with Excel Learning Series. Master functions, filtering, linking, PivotTables, charts and graphics, macros, and more!
Click Here to Choose Your Excel Training

Go To Top of Page
 



Tips, Tricks, Secrets you need to know now!
Discover the secrets you wish you knew before...all of this plus 15 BONUS SHORTCUTS and access to handouts with 477+ MORE SHORTCUTS AND TIPS when you
sign-up for the Smart & Easy Software Tips & Tricks eMagazine!

Start Being More Productive Today!
CLICK HERE to
sign-up by email.
Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
 
www.SoftwarePro.com
HomeContact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 1995-2013 The Software Pro® & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
§ Dawn@SoftwarePro.com § 11675 Bent Oaks Street, Suite 200; Parker, Colorado 80138 USA § www.SoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
§ Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
§ Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist (MOS) Master Instructor
§ Certified Microsoft Office Expert § Certified Women's Business Enterprise (WBE)
The Software Pro
® is a registered trademark
Terms & Conditions       Privacy Policy