Skip to content
Tutorials Center
My learning

Topics

Lesson 3 of 29 ยท Getting Started

Entering and Editing Data

Type, edit and autofill data in Google Sheets, learn how Sheets decides whether an entry is text, a number or a date, and fix surprises quickly.

Typing into a cell looks trivial, but one decision happens behind it every time: Sheets looks at what you typed and decides whether it is text, a number, a date, a boolean or a formula. That decision controls alignment, sorting and, above all, whether calculations work. Most beginner problems ("my sum is zero", "my date turned into a number") trace back to it.

This lesson covers the mechanics of entering and editing, the fill handle, how input is classified, and how to undo and recover. The GUI actions are described in words; the TryIt blocks are stand-ins that model the classification and fill logic, not the real Google code.

Typing and editing

Click a cell and type; the text appears both in the cell and in the formula bar. Then confirm:

Key Result
Enter Confirm and move down
Tab Confirm and move right
Shift+Enter / Shift+Tab Confirm and move up / left
Esc Cancel the edit and keep the old content
F2 or double-click Edit the existing content instead of replacing it
Alt+Enter (Option+Enter on Mac) Start a new line inside the cell
Delete Clear the content but keep the formatting

Typing over a selected cell replaces its content, which surprises people who wanted to add a word. Press F2 (or double-click) to enter edit mode first.

Entering a table row by row with Tab at the end of each cell and Enter at the end of the row is the fastest way. After Tab, Tab, Enter, Sheets returns to the column where you started the row.

How Sheets decides what you typed

The cell shows clues. Numbers and dates are right-aligned by default, text is left-aligned, and TRUE or FALSE are centered. Alignment is a quick check that a column holds what you think it does. A cell containing a number stored as text (a classic problem after copying from a website) is left-aligned and is ignored by SUM.

One entry, five possible types

Number 42, 3.5, -7, 1,250, 12%
Date 3/14/2026, 2026-03-14
Text Anything else, such as Rent or A-12.
Boolean TRUE or FALSE
1 / 2

The rules are locale-dependent. In a US English spreadsheet 3/4/2026 is March 4, while in many other locales it is April 3. Check File > Settings for the spreadsheet's locale and time zone before you type dates in bulk. The stand-in below uses US English rules and deliberately stays small.

JS How input is classified

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Look at 007: it becomes the number 7, because it is a valid number. If leading zeros matter (ZIP codes, product codes, phone numbers), format the column as Plain text before typing (Format > Number > Plain text), or start each entry with an apostrophe. The apostrophe is not stored in the cell and is not shown in it, only in the formula bar. Also notice 2026-02-30: an impossible date is not a date, so it stays text.

Typing numbers

Do not type the thousands separator, currency symbol or units unless you mean it. Type 1250 and apply a currency format later (see Formatting Cells). Typing 5 kg makes text that no formula can add up. Put the unit in the header (Weight (kg)) and keep the cells numeric. Use the locale's decimal mark: a comma in some locales, a dot in others.

The fill handle and autofill

Select a cell or a block, then drag the small blue square at its bottom right corner, the fill handle. Sheets continues the pattern. Double-clicking the handle fills down as far as the neighbouring column has data, which saves a lot of dragging.

  • A single number is copied. Type 1 and drag: you get 1, 1, 1.
  • Two or more numbers define a step. 10 and 20 continue as 30, 40, 50.
  • Text with a number at the end, such as Item 1, counts up: Item 2, Item 3.
  • Days and months (Mon, Monday, Jan, January) continue in their cycle.
  • Dates continue day by day, or by the step between two selected dates.
  • A formula is copied with its references adjusted, which is the topic of Relative, Absolute and Mixed References.

Autofill is a guess. When Sheets cannot detect a pattern it copies the content. After a drag, a small Auto fill button can offer a choice such as "Copy cells" or "Fill series".

JS A tiny autofill

Press Run (or Ctrl + Enter) to see the console output here.

No output.

This stand-in shows the rule of thumb. The real feature knows many more patterns (months, dates, custom lists) and works in two dimensions.

Editing, moving and undoing

  • Undo with Ctrl+Z (Cmd+Z) and redo with Ctrl+Y (Cmd+Shift+Z). Undo goes back many steps, but for a bigger rescue use version history (Sharing, Comments and Version History).
  • Copy and paste (Ctrl+C, Ctrl+V) copies content and formatting. Paste special (Ctrl+Shift+V pastes values only) keeps the destination's look, and it also turns formulas into their results.
  • Drag to move: select a block, hover over its border until the cursor changes to a hand, then drag.
  • Find and replace: Ctrl+H. You can search within formulas and limit the search to one sheet.
  • Insert and delete rows or columns from the right-click menu. Deleting a row that formulas depend on can produce #REF! errors (see Understanding Formula Errors).

Pressing Delete clears values but leaves formatting. Deleting a row or column removes the cells themselves and shifts the rest. Choose carefully, and remember Undo is always one shortcut away.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. You type 007 into a cell with the default format. What does Sheets store?

    007 is a valid number, so the leading zeros are dropped. Use Plain text format or a leading apostrophe to keep them.
  2. 2. A column of numbers is left-aligned and SUM returns 0. What is the likely cause?

    Left alignment suggests text. SUM ignores text, so numbers stored as text are not added.
  3. 3. You select 10 and 20, then drag the fill handle down three cells. What appears?

    Two numbers define a step of 10, so autofill continues the series with 30, 40 and 50.
  4. 4. Which key leaves edit mode and cancels your typing?

    Esc cancels the edit and restores the old content. Enter and Tab confirm it.

Summary

  • Sheets classifies every entry as a number, date, text, boolean or formula, and alignment hints at the result.
  • Start with = for a formula and with ' to force text; format a column as Plain text before typing codes with leading zeros.
  • Type bare numbers and apply formats afterwards; keep units out of the cells.
  • The fill handle continues patterns: steps from two numbers, counting text, weekdays and dates.
  • Undo with Ctrl+Z, and use Paste special to keep values or formats separate.

Next: Formatting Cells