How to perform Data Entry in Excel (Writing and Moving) : Lesson 29 — ComputerSeekhoAurJobPao

Lesson 29: How to Enter Data in Excel (Typing and Moving Around)

Hinglish English हिन्दी

What You Will Learn

• How to Type in Excel
• The Right Use of Enter and Tab
• Arrow Keys (Four Directions)
• What to Do When You Make a Mistake
• Office Glossary
• Today's Practice

So far you have understood Excel and recognised the screen. Today we will type data in Excel for the first time. Typing in Excel is just like normal typing — the only difference is that everything is written inside separate boxes called Cells.

1. How to Type in Excel

To type in Excel:

• • Click once on the Cell where you want to type
• • Start typing on your keyboard

Whatever you type will appear inside the Cell and also in the Formula Bar at the top.

When you click on a cell, a border appears around it. This is called the Active Cell. In Excel, all typing always happens inside the Active Cell.

2. The Right Use of Enter and Tab (Speed Magic)

Using the mouse to move from one cell to another is slow. Remember these two keyboard keys instead:

Enter Key

Pressing Enter moves the cursor to the cell below. Excel is designed this way by default because it is built for creating lists and tables. This is useful when you are building a list.

Example: Name → Ravi → Sita → Aman

Tab Key

Pressing Tab moves the cursor to the cell on the right. This is useful when you are writing headings across a single row.

Example: Name | City | Phone

3. Arrow Keys (Four Directions)

The arrow keys on your keyboard are also used for navigation:

• • Up Arrow: Move up
• • Down Arrow: Move down
• • Left Arrow: Move left
• • Right Arrow: Move right

4. What to Do When You Make a Mistake

If you have typed something wrong in a cell:

Method 1 (Easy): Double-click on the cell and correct the mistake.

Method 2: Click on the cell and press the F2 key. (On some laptops, F2 may work only with the fn key — in that case press fn + F2.) This places the cursor inside the cell so you can edit the text.

How to Delete a Letter:

• • Backspace: Deletes the letter to the left of the cursor
• • Delete Key: Deletes the letter to the right of the cursor

If you accidentally move to the wrong cell, do not worry. Use the arrow keys or mouse to come back to the correct cell. If you accidentally delete something, press Ctrl + Z to Undo and bring it back.

5. Office Glossary

• Data Entry: Typing information into a computer
• Navigation: Moving from one cell to another
• Overwrite: Replacing existing data by typing new data over it
• Active Cell: The cell in which typing is currently happening

Today's Practice

Open Excel and create this small list:

1️⃣ In Cell A1 type: Name — then press Tab
2️⃣ In Cell B1 type: City — then press Tab
3️⃣ In Cell C1 type: Phone
4️⃣ Now press Enter and move down
5️⃣ Enter the data of 3 of your friends

Example format:
Ravi | Delhi | 98xxxx
Aman | Jaipur | 97xxxx
Sita | Lucknow | 99xxxx

Now use the Arrow Keys to check whether you can move between cells.

💡 Tip: Always check where the Active Cell is in Excel. For fast data entry in the office — Left hand → Tab key | Right hand → Enter key.

What You Learned in This Lesson:

• You can click on any cell in Excel and start typing immediately
• The Enter key moves the cursor down — useful for building lists
• The Tab key moves the cursor to the right — useful for writing headings
• Arrow keys let you navigate in all four directions
• To correct a mistake, use Double Click or the F2 key
• If something is accidentally deleted, press Ctrl + Z to Undo

← Previous Home Next →

---

Home | About | Index | Welcome | Contact | Privacy Policy