Typing data in Excel cells is one of the first skills every beginner needs to learn.

Before you can use formulas, create charts, build reports, or analyze data, you need to know how to enter information correctly into Excel.

The good news is that typing data in Excel is simple. You click a cell, type your information, and press Enter.

But there are also important things beginners should understand, such as how to enter text, numbers, dates, long sentences, and formulas.

In this guide, you will learn how to type data in Excel cells step by step.

What Is a Cell in Excel?

A cell is one small box in the Excel grid.

It is where you enter data.

Every cell has a cell address. The address is created using the column letter and row number.

For example:

• A1 means column A, row 1
• B2 means column B, row 2
• C5 means column C, row 5

When you click a cell, Excel highlights it with a border. This selected cell is called the active cell.

Anything you type will go into the active cell.

What Type of Data Can You Type in Excel Cells?

You can type different types of data in Excel cells.

The most common types are:

• Text
• Numbers
• Dates
• Times
• Percentages
• Currency values
• Formulas

For example, you can type a person’s name, a product price, a date, or a formula that calculates a total.

Excel is flexible, which is why it is useful for lists, budgets, reports, sales records, school marks, and business data.

How to Type Data in an Excel Cell

Typing data in Excel is easy.

Follow these steps:

1. Open Microsoft Excel.
2. Click a blank cell.
3. Type your data.
4. Press Enter on your keyboard.

For example, click cell A1 and type:

Name

Then press Enter.

Excel will move to the cell below.

You have now entered your first data in Excel.

How to Type Text in Excel Cells

Text is any information that is not mainly used for calculation.

Examples of text include:

• Names
• Product names
• Locations
• Notes
• Categories
• Titles
• Descriptions

For example, you can type:

A	B
Name	Location
Mary	Nairobi
John	Mombasa

To enter text, click a cell and type normally.

Excel usually places text on the left side of the cell.

This helps you quickly know that the cell contains text.

How to Type Numbers in Excel Cells

Numbers are values that Excel can use in calculations.

Examples of numbers include:

• 100
• 2500
• 75
• 12.5
• 30000

For example, you can create a simple sales table:

Product	Quantity
Shoes	4
Bags	2
T-Shirts	5

To enter a number, click a cell, type the number, and press Enter.

Excel usually places numbers on the right side of the cell.

This helps you quickly know that Excel recognizes the value as a number.

How to Type Dates in Excel Cells

Excel can also work with dates.

You can type dates in cells like this:

• 12/06/2026
• June 12, 2026
• 12-Jun-2026

For example:

Task	Due Date
Submit report	12/06/2026
Pay rent	30/06/2026
Team meeting	05/07/2026

Dates are useful for calendars, schedules, invoices, attendance sheets, project plans, and reports.

If Excel recognizes your entry as a date, it may automatically format it.

How to Type Time in Excel Cells

You can also type time in Excel.

Examples include:

• 8:00 AM
• 2:30 PM
• 14:30
• 9:15

For example:

Activity	Time
Meeting	9:00 AM
Lunch	1:00 PM
Training	3:30 PM

Time entries are useful for timetables, work schedules, attendance records, and event plans.

How to Type Currency Values in Excel

If you are working with money, you can type the amount as a number first.

For example:

Item	Amount
Rent	15000
Food	8000
Transport	5000

After typing the numbers, you can format them as currency.

For example, you can make them appear as:

• KSh 15,000
• $150
• £80
• €200

It is usually better to type clean numbers first, then apply currency formatting later.

This helps Excel calculate the values correctly.

How to Type Percentages in Excel

You can type percentages directly in Excel.

For example:

• 10%
• 25%
• 50%
• 75%

A percentage is useful when working with discounts, marks, taxes, commissions, progress, or interest rates.

Example:

Item	Discount
Shoes	10%
Bags	15%
T-Shirts	20%

When you type the percent sign, Excel understands the value as a percentage.

How to Type a Formula in Excel

A formula is an instruction that tells Excel to calculate something.

Every Excel formula starts with an equal sign:

=

For example, if you want to add 10 and 20, you can type:

=10+20

Then press Enter.

Excel will show the answer:

30

You can also use cell references.

For example, if cell A1 has 10 and cell B1 has 20, you can type this in cell C1:

=A1+B1

Excel will add the values in A1 and B1.

Example of Typing Data and a Formula

Here is a simple example:

Item	Price	Quantity	Total
Shoes	1500	3	=B2*C2
Bags	2500	2	=B3*C3

In this example:

• The product name is text
• The price is a number
• The quantity is a number
• The total uses a formula

This is one of the most common ways Excel is used.

How to Edit Data in an Excel Cell

Sometimes you may type the wrong information.

To edit data in a cell, you can use any of these methods.

Method 1: Double-Click the Cell

Double-click the cell you want to edit.

Make your changes.

Press Enter.

Method 2: Use the Formula Bar

Click the cell.

Go to the formula bar at the top.

Edit the text, number, or formula.

Press Enter.

Method 3: Replace Everything in the Cell

Click the cell once.

Type the new information.

Press Enter.

This will replace the old content completely.

How to Delete Data from a Cell

To delete data from a cell:

Click the cell.

Press the Delete key on your keyboard.

The cell will become empty.

You can also select many cells and press Delete to clear all of them at once.

How to Move from One Cell to Another

When typing data in Excel, you need to move around the worksheet.

Here are common keys you can use:

• Press Enter to move down
• Press Tab to move right
• Press Shift + Tab to move left
• Use arrow keys to move up, down, left, or right
• Click any cell with your mouse to select it

These simple movements make data entry faster.

How to Type Long Text in a Cell

Sometimes you may need to type a long sentence or note in a cell.

For example:

Customer requested delivery before Friday morning.

If the text is too long, it may appear to overflow into the next cell.

This does not mean the text is lost.

To make long text easier to read, you can use Wrap Text.

Wrap Text makes the text appear on multiple lines inside the same cell.

To use Wrap Text:

• Click the cell.
• Go to the Home tab.
• Click Wrap Text.

Now the full text can be seen inside the cell.

How to Start a New Line Inside the Same Cell

Sometimes you may want to type multiple lines inside one cell.

To start a new line inside the same cell, use this shortcut:

Alt + Enter

For example, you can type:

Payment received

Then press Alt + Enter

Then type:

Receipt sent to customer

This keeps both lines inside the same cell.

How to Copy Data into Excel Cells

You do not always have to type everything manually.

You can copy data from another place and paste it into Excel.

For example, you can copy data from:

• A Word document
• A website
• An email
• A PDF
• Another Excel file
• A text file

To copy and paste:

Select the data.

Press Ctrl + C to copy.

Click the cell where you want the data to start.

Press Ctrl + V to paste.

Be careful when pasting data because it may not always appear perfectly. You may need to adjust the columns or clean the data.

How to Type Data in Several Cells

Excel works best when information is arranged in a table.

For example, instead of typing everything in one cell, separate the information into different columns.

Poor example:

A

Mary Nairobi 0722000000 Paid

Better example:

Name	Location	Phone	Status
Mary	Nairobi	0722000000	Paid

The second example is better because each piece of information has its own cell.

This makes sorting, filtering, and analysis easier.

How to Enter Data Correctly in Excel

Good data entry is important.

If you enter data poorly, your Excel file may become difficult to use.

Here are some good habits.

Use Clear Column Headings

Always use headings at the top of your table.

For example:

Customer Name

Phone Number

Location

Payment Status

Headings help you understand what each column contains.

Keep One Type of Data in Each Column

Do not mix different types of data in one column.

For example, do not put names and phone numbers in the same column.

Use one column for names and another column for phone numbers.

Avoid Blank Rows Inside a Table

Blank rows can cause problems when sorting or filtering data.

Try to keep your table continuous.

Be Consistent

Use the same format throughout your table.

For example, if you write “Paid” in one row, do not write “paid”, “PAID”, and “Payment done” in other rows unless you have a reason.

Consistency makes Excel easier to analyze.

Do Not Add Extra Spaces

Extra spaces can cause problems.

For example, Mary and Mary may look similar, but Excel can treat them differently because one has an extra space.

Type carefully and avoid unnecessary spaces.

How Excel Understands What You Type

Excel tries to understand the data you enter.

If you type words, Excel treats them as text.

If you type numbers, Excel treats them as values that can be calculated.

If you type something starting with =, Excel treats it as a formula.

If you type a date, Excel may format it as a date.

This automatic behavior is useful, but beginners should pay attention to it.

For example, if you type a phone number starting with zero, Excel may remove the first zero.

This is because Excel may think it is a number.

How to Type Phone Numbers in Excel

Phone numbers can be tricky because some begin with zero.

For example:

0722123456

Excel may change this to:

722123456

This happens because Excel treats it as a number and removes the leading zero.

To avoid this, format the column as text before typing phone numbers.

Another quick method is to type an apostrophe before the phone number:

'0722123456

The apostrophe tells Excel to treat the value as text.

The apostrophe will not usually show in the cell after you press Enter.

How to Type Numbers Without Excel Changing Them

Sometimes Excel may automatically change what you type.

This can happen with phone numbers, ID numbers, codes, or product numbers.

For example, Excel may change:

00125

to:

125

To keep the zeros, type the value as text.

You can either:

• Format the cells as Text before typing
• Type an apostrophe before the value

Example:

'00125

This helps Excel keep the value exactly as typed.

Common Data Entry Mistakes Beginners Make

One common mistake is typing everything into one cell instead of separating information into columns.

Another mistake is forgetting to press Enter after typing.

Some beginners also type numbers with extra spaces, which can cause formulas to fail.

Others type phone numbers as normal numbers and lose the first zero.

Another common mistake is overwriting existing data by clicking a filled cell and typing new information.

Always check the active cell before typing.

Beginner Practice Exercise

Try this simple practice exercise.

Open Excel and type the following table:

Name	Item	Quantity	Price
Mary	Shoes	2	1500
John	Bag	1	2500
Peter	T-Shirt	3	800

Then add a new column called:

Total

In the first total cell, type:

=C2*D2

Press Enter.

This formula multiplies quantity by price.

You have now typed text, numbers, and a formula in Excel.

Beginner Tips for Typing Data Faster

Use Tab to move to the next cell on the right.

Use Enter to move to the cell below.

Use Ctrl + C and Ctrl + V to copy and paste.

Use Ctrl + Z to undo a mistake.

Use Ctrl + S to save your work.

Use headings to organize your data.

Keep each piece of information in its own cell.

These simple habits will make you faster and more confident in Excel.

Key Takeaways

• A cell is one box in Excel where you type data.
• The active cell is the selected cell where your data will go.
• You can type text, numbers, dates, times, percentages, currency values, and formulas.
• Press Enter after typing to save the entry in the cell.
• Press Tab to move to the next cell on the right.
• Every formula in Excel starts with an equal sign.
• Use Wrap Text for long text.
• Use Alt + Enter to start a new line inside the same cell.
• Keep one type of data in each column.
• Format phone numbers or ID numbers as text to keep leading zeros.