| |
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
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
|
| |
|
Tips, Tricks, Secrets you need to know now!
|
|
