Exceljet

Quick, clean, and to the point

How to edit data in Excel

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.

Course 

Related shortcuts

Author 
Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.