BeginnerLesson 2 of 305 min read

Entering and editing data the right way

Learn the difference between text, numbers and dates, how to type and edit quickly, and how to lay data out so Excel can work with it.

In this lesson you will

  • Tell text, numbers and dates apart
  • Type, edit and autofill quickly
  • Spot numbers stored as text
  • Lay out data as a clean table

About 14 minutes

Why does my total not add up?

Karan types the marks of his class into a sheet and asks Excel to add them. The total is lower than it should be. He checks the numbers again and again: they all look right. The problem is invisible: three of the marks were pasted from a website and Excel is treating them as text, not numbers. This lesson is about entering data so that Excel understands it, and about the habits that save you from these quiet problems.

Three kinds of entries

Kind Examples Default alignment
Text Notebook, Delhi, Rs 123 Left
Numbers 40, 3.5, -20 Right
Dates and times 5/3/2026, 14:30 Right

The alignment is a handy clue. If a number sits on the left of its cell, Excel is probably treating it as text. The sheet below was really recalculated to check this. A1 holds the number 123, A2 holds ‘123’ stored as text, and A3 holds the words ‘Rs 123’:

Cell Test Result
A1 =ISNUMBER(A1) True
A2 =ISNUMBER(A2) False
A3 =ISNUMBER(A3) False

Now add them: =SUM(A1:A3) gives 123. Only the true number was added. SUM quietly ignores text, which is exactly how Karan’s total came out too small.

Dates are numbers in disguise

Excel stores each date as a number: the count of days since a starting date. The first of January 2026 is stored as 46023 and the second as 46024, so the difference between them is 1 day. This is why you can subtract dates to count days. It also means a date cell must be recognised as a date: type it in the format your computer uses (for example 5/3/2026 or 5-Mar-2026) and Excel will convert it.

Good to know

Day-month-year or month-day-year? It depends on your computer’s regional settings, so check by typing a date such as 13/1/2026. If Excel keeps it as text, your computer expects month first.

Typing and editing

  1. Click a cell and type. Press Enter to accept and move down, Tab to move right, or Esc to cancel.
  2. To change a cell, select it and press F2 (or double-click). Retyping over a selected cell replaces it.
  3. To clear a cell, select it and press Delete.
  4. To undo a mistake, press Ctrl+Z; to redo, Ctrl+Y.

Saving time while typing

  • Autofill: type Monday, then drag the small square at the cell’s bottom-right corner (the fill handle). Excel continues with Tuesday, Wednesday … Months, numbers and dates work too.
  • Series from two cells: type 10 and 20, select both, and drag the handle to continue 30, 40, 50.
  • Copy and paste: Ctrl+C, then Ctrl+V. Use Ctrl+X to move.
  • Ctrl+Enter: fill the same entry into every selected cell at once.

Laying out data so Excel can work with it

A good data sheet is a plain table. Follow these rules and sorting, filtering, charts and formulas will all work smoothly later:

  • One header row at the top, with a short name for each column.
  • One record per row (one sale, one student, one expense).
  • One kind of thing per column (all dates in one column, all amounts in another).
  • No blank rows or columns inside the table.
  • Do not put totals in the middle of the data; keep them to one side or below.
  • Do not merge cells inside the data.

Spelling and spaces count

To a computer, ‘Delhi’, ‘Delhi ‘ (with a space on the end) and ‘delhi’ can look like different things. In a test sheet, counting the cells equal to ‘Delhi’ with =COUNTIF(F1:F3,”Delhi”) returned 2 out of three. The sheet really contains Delhi, Delhi with a trailing space, and delhi. Excel ignores capital letters in this kind of comparison but not the extra space, so one of the three is missed. When you build lists, type each value the same way every time.

Practice

Make a sheet with five students, their names, an exam date and a mark out of 100. Type the dates properly, check that marks are right-aligned, use autofill for a roll number column and finish with a cell that adds the marks. If the total looks too small, check the alignment of every mark.

Practice answer

If one mark is left-aligned, retype it. If the problem came from pasted data, select the cells and use Data, Text to Columns, then Finish, which forces Excel to re-read the entries. Also look for a small green triangle in a cell’s corner: Excel is warning that a number is stored as text.

Common mistake

Adding units inside the cell, such as typing 40 kg or Rs 500. That turns a number into text. Type the number alone and put the unit in the header or the number format.

Check what you learned

Five quick questions. Pick an answer and you will see straight away whether it is right and why.

A number is left-aligned in its cell. What is the likely cause?

  1. It is a date
  2. It is stored as text
  3. It is too big
  4. The sheet is protected

Numbers align right by default.

Why did SUM ignore a value in the test sheet?

  1. It was negative
  2. It was a date
  3. It was stored as text
  4. It was zero

SUM adds only true numbers.

How does Excel store a date?

  1. As a number of days
  2. As a picture
  3. As a colour
  4. As a formula bar

That is why dates can be subtracted.

Which key edits the selected cell without retyping?

  1. F1
  2. Esc
  3. F2
  4. Tab

F2 puts the cell into edit mode.

Which layout is best for a data table?

  1. One header row and one record per row
  2. Blank rows between records
  3. Merged title cells inside
  4. Totals in the middle

A plain table works with every tool.

Summary

  • Numbers align right; left-aligned numbers are probably text.
  • Dates are stored as numbers of days.
  • Keep data in a plain table: header row, one record per row.
  • Spelling and extra spaces change results.

Next lesson

Next: your first formulas.

Questions

Why does my number show as 1.23E+10?

The column is too narrow, or the number is long. Widen the column or change the number format.

How do I stop Excel changing 1-2 into a date?

Format the cell as Text before typing, or type an apostrophe first, as in '1-2.

What is the green triangle in a cell?

A warning flag. Click the cell and the small icon to see the reason, such as a number stored as text.

Progress is saved in this browser.