Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to edit data in Excel

How to edit data in Excel

Transcript 

In this lesson, we'll look at how to edit information that's already been entered into Excel.

Let's take a look.

If you want to replace information, just select a cell and start typing. Then type enter or tab to confirm. The contents of the cell will be completely replaced by the new information.

If you want to revise the contents of a cell, double-click the cell and edit the content as you like. Then type enter or tab to confirm the change.

Another way to edit content already in a cell is to press the F2 key. Like double-clicking, this brings the cursor into the cell where you can make changes.

You can also select a cell, and make revisions in the formula bar. You might find this way is more convenient when a cell contains a lot of information, or when you want to edit a formula.

As before, if you don't want to accept the changes you've begun, just press the escape key, and no change will be made.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Thank you, this is an excellent site to get an understanding of all the Excel formulas. Especially for brushing up or just rechecking the formulas.
Priti
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page