Excel Basics · ~3 min read

How to Enter and Edit Data in Excel (Beginner Tutorial)

Type in cells, move with Tab and Enter, edit with F2, understand text vs numbers vs dates, and cancel or undo.

Video link coming soon
What you will learn

Step by step

1. Intro

Welcome to Excel Basics. In this lesson, you will learn how to enter and edit data in cells.

You will type text, numbers and dates, move around with the keyboard, fix mistakes, and undo what you did.

How to Enter and Edit Data in Excel (Beginner Tutorial): Intro
Intro

2. Meet the cell

Every worksheet is a grid of cells, and every cell has an address. We will build a small expense list, starting in cell A1.

How to Enter and Edit Data in Excel (Beginner Tutorial): Meet the cell
Meet the cell

3. Type in a cell

To enter data, select a cell and just start typing. There is no need to double-click first.

Let's type the word Item.

The text appears in the cell and in the formula bar at the same time.

Look at the status bar at the bottom. It says Enter, which means Excel is waiting for you to finish the entry.

How to Enter and Edit Data in Excel (Beginner Tutorial): Type in a cell
Type in a cell

4. Enter and Tab

Press Tab to confirm the entry and move one cell to the right.

Type Price, then press Enter. Excel moves down, to the start of the next row.

Now type Coffee, press Tab, type four point five, and press Enter.

How to Enter and Edit Data in Excel (Beginner Tutorial): Enter and Tab
Enter and Tab

5. Keep going

Continue with Notebook, Tab, three point two five, Enter.

And finally, Bus pass, Tab, thirty, Enter.

It quickly becomes a rhythm: type, Tab, type, Enter. You never need the mouse.

How to Enter and Edit Data in Excel (Beginner Tutorial): Keep going
Keep going

6. Typing tips

Excel also helps while you type. If you start a word that already exists in the column, it suggests the rest. Click A5, and type the letters C and O.

See the suggestion, Coffee? Press Enter to accept it, or keep typing to ignore it. We will press Escape and cancel.

Long text spills into the empty cells on its right. Click F1 and type a long sentence.

If the cell on the right is not empty, the text gets cut off. To clear a cell, select it and press Delete.

Numbers that start with zero, like zero zero seven, lose their zeros. Start with an apostrophe, and Excel keeps it as text.

Type twenty-five and the percent sign in E2, and Excel stores a real percentage.

Control and semicolon types today's date for you. Try it in E3.

Alt and Enter start a new line inside the same cell. Click A8, type Line one, press Alt Enter, type Line two, and press Enter.

To type the same entry in many cells, select them, type, and press Control and Enter. Let's fill H1 to H3 with OK.

Let's clear these practice cells. Select them and press Delete. A tip: if you ever clear too much, Control Z brings it back.

Shortcut: Ctrl + ;

How to Enter and Edit Data in Excel (Beginner Tutorial): Typing tips
Typing tips

7. Text, numbers and dates

Notice that the text lines up on the left side of its cell, while the numbers line up on the right.

That is how Excel knows what kind of data you entered. Text stays left, and numbers go right.

Dates work too. Click C1 and type Date, press Enter, then type a date such as eleven, twelve, twenty twenty-six.

Excel recognized it as a date, so it lined up on the right, just like a number.

How to Enter and Edit Data in Excel (Beginner Tutorial): Text, numbers and dates
Text, numbers and dates

8. Edit a cell

To fix a mistake, select the cell and type again. The new entry replaces everything that was in the cell.

Let's select B2 and type five. The old price is gone.

To change just part of an entry, select the cell and press F2. Now you can edit inside the cell.

Let's turn Notebook into Notebooks. Type the letter s, and press Enter.

Now select B4 and type thirty-five to replace the old bus pass price.

How to Enter and Edit Data in Excel (Beginner Tutorial): Edit a cell
Edit a cell

9. Cancel and undo

Changed your mind before confirming? Start typing something in an empty cell, like A5.

Press Escape, and the entry is cancelled. Nothing is saved.

Once you have confirmed an entry, you can still take it back. Type Taxi and press Enter.

Now press Control and Z. The entry disappears. That is Undo, and it can rescue you from almost any mistake.

How to Enter and Edit Data in Excel (Beginner Tutorial): Cancel and undo
Cancel and undo

10. Recap

Let's recap. Select a cell and type to enter data. Tab moves right, and Enter moves down.

Typing over a cell replaces it, F2 edits inside it, Escape cancels, and Control Z undoes.

Next time, you will learn to select, copy and fill data quickly.

Thanks for watching, and see you in the next lesson.

How to Enter and Edit Data in Excel (Beginner Tutorial): Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Excel Workbooks, Worksheets and Cells Explained
Next tutorial: Select, Copy, Move and AutoFill in Excel (Fast Way) →