Entering and editing data

Introduction

Everything in a spreadsheet starts with typing data into cells. Excel looks at each entry and decides what it is: a number, a piece of text, a date or a formula. Most problems later on, such as sums that ignore some numbers or dates that cannot be sorted, come from data that Excel read differently from what you meant. This lesson shows how Excel decides, how to edit safely, and how to let Excel do the repetitive typing for you.

How it works

Type into a cell and press Enter (to move down) or Tab (to move right). Excel then decides the data type:

  • Numbers such as 150, 3.5, -20 or 12% are aligned to the right by default.
  • Text such as Pen or ID-07 is aligned to the left.
  • Dates such as 13/11/2026 or 2026-11-13 are recognised according to your computer's regional settings and stored as numbers (a later lesson explains how).
  • Anything starting with = is a formula.

A number stored as text, for example a value imported from another system, is aligned left and often shows a small green triangle in the cell's corner. Such cells are ignored by SUM. To keep leading zeros on purpose, as in a phone number, type an apostrophe first: '01711 is stored as text and shown as 01711.

To edit a cell, select it and press F2, double-click it, or click in the formula bar. Press Enter to keep the change, or Esc to cancel it. Typing straight into a selected cell replaces everything in it. Delete clears the contents but keeps the formatting; Clear All on the Home tab removes both.

AutoFill continues a pattern. Type Monday in a cell and drag the fill handle downwards: Excel fills Tuesday, Wednesday and so on. Type 1 and 2 in two cells, select both and drag: Excel continues 3, 4, 5. Double-clicking the fill handle fills down as far as the column next to it has data, which is perfect for copying a formula down a long table.

Flash Fill, available since Excel 2013, learns from examples. If column A holds full names, type the first name of the first person in column B, start typing the second, and Excel suggests the rest; press Enter to accept, or use Data, Flash Fill. It is a one-off result, not a formula, so it does not update when column A changes.

Paste Special copies only part of what you copied: values without formulas, formats only, or a transposed copy that turns rows into columns.

Example

An HR list holds full names, and the manager needs first names for a mail merge:

AB
1Full nameFirst name
2Ada Lovelace
3Alan Turing
4Grace Hopper

Line by line

  1. Click B2 and type Ada, then press Enter.
  2. In B3 type A: Excel shows a grey suggestion of Alan, Grace in the cells below.
  3. Press Enter to accept the suggestion. If no suggestion appears, select B2 and press Ctrl+E (Windows) or choose Data, Flash Fill.
  4. Check a few results against column A, because Flash Fill guesses the pattern.

Expected result

Column B shows Ada, Alan and Grace. They are plain text values: if you later change A3 to Alan Kay, B3 still says Alan until you run Flash Fill again.

In the real world

Data rarely arrives clean. Exports from accounting systems put numbers in as text, dates arrive in another country's order, and names need splitting into parts. Recognising data types at a glance, by alignment and by the green triangle, is how experienced users catch these problems before they spoil a report.

Common mistakes

  • Numbers stored as text, which SUM ignores; convert them with the warning menu or Data, Text to Columns.
  • Dates typed in the wrong order for the computer's region, so 05/07 becomes the wrong month.
  • Typing over a formula by accident; the result looks fine until the data changes.
  • Treating Flash Fill results as formulas that will update themselves.

Best practices

  • Type each kind of value in its own column: one column for quantities, another for units.
  • Use AutoFill and double-click the fill handle instead of copying by hand.
  • After pasting from elsewhere, check alignment and the formula bar for numbers stored as text.

Keyboard shortcuts

ActionWindowsMac
Edit the active cellF2Control+U
Cancel an entryEscEsc
New line inside a cellAlt+EnterOption+Return
Fill the selection with the current entryCtrl+EnterControl+Return
Fill down from the cell aboveCtrl+DCommand+D
Fill right from the cell on the leftCtrl+RCommand+R
Flash FillCtrl+E—
Insert today's dateCtrl+;Control+;
Paste SpecialCtrl+Alt+VControl+Command+V
UndoCtrl+ZCommand+Z
RedoCtrl+YCommand+Y

Summary

Excel reads each entry as a number, text, date or formula; alignment and the formula bar show what it decided. Edit with F2 or a double-click and cancel with Esc. AutoFill continues series and copies formulas down, Flash Fill fills a column from a pattern you show it, and Paste Special pastes only the part you want.

Quick check

1. By default, how is a number aligned in a cell?
2. How do you keep the leading zero in 01711?
3. What happens to Flash Fill results when the source column changes?
4. What does double-clicking the fill handle do?

Key takeaways

  • Numbers align right and text aligns left by default, which is a quick check of what Excel stored.
  • Edit a cell with F2 (Windows) or by double-clicking, and press Esc to cancel a change.
  • AutoFill continues patterns; Flash Fill learns a pattern from examples.
My notes

Write down what you want to remember from this lesson. Notes are saved on this device as you type, and appear on your dashboard.