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 Newsletter Media Room Contact
Tip: Editing Cells  

Training
Speaking
Consulting
Tips & Tricks
The Pro Shop
How-To Lessons
Free Articles
Newsletter
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

Editing a Cell
Options for editing text, values or a formula in a worksheet cell include:excel editing tips, tricks, editing cells, worksheets, excel 2010, excel 2007

  • Typing a new entry in cell (no need to delete previous contents)
  • Double-click on cell to open "in-place editing"
  • Click once into the formula bar (above column headings)
  • Press [F2] to open cell for editing
  • Press [Delete] to clear contents (cell is empty but retains formatting)

When a cell is opened for editing, click with the mouse or use arrow keys, [Backspace], [Delete], [Home] and [End] to navigate in the cell.

>>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 that 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 350+ 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 directly via email.
Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
 
www.SoftwarePro.com
HomeServices | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 1995-2011 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