📊 Lesson 1.3: Entering, Editing & Formatting Data

Your starter sheet has data in it — now let's make it good data: entered the right way, edited quickly, and formatted so a person can read it at a glance. In this lesson you'll learn the data types Sheets understands, the fast ways to type and edit, the fill handle that saves you hundreds of keystrokes, and the formatting that turns a raw grid into a clean, professional-looking table.

📚 What You'll Learn

By the end of this lesson, you will be able to:

Recognize the data types Sheets understands — numbers, text, dates, currency, percentages, and booleans — and why alignment tells you the type
Enter and edit data efficiently with double-click / F2, Enter vs Tab, and undo
Use the fill handle and autofill to extend series and copy patterns in seconds
Apply the formatting that matters — currency, dates, percent, decimals, alignment, wrapping, borders, and color
Freeze the header row and adjust sizing so a growing table stays readable

⏱️ Estimated Time: 50 minutes

🎯 Project: Enter a small realistic dataset (a week of budget rows or a task list) with proper data types, then format it cleanly — styled header, currency/date formats, and a frozen header row.

In This Lesson

The Data Types Sheets Understands

When you type into a cell, Sheets doesn't just store your keystrokes — it tries to figure out what kind of thing you entered. This is called data type detection, and it matters enormously. A cell that holds a real number can be summed, averaged, and charted; a cell that holds text that just looks like a number cannot. Getting your types right from the start is the difference between a sheet that calculates and one that quietly refuses to.

Here are the types you'll meet, and how Sheets treats each:

Type	Examples	How Sheets treats it
Number	`42`, `3.14`, `-8`	A true value you can calculate with; right-aligned by default
Text	`Groceries`, `Sam's shop`	Labels and words; left-aligned by default; not used in math
Date / time	`2026-01-05`, `14:30`	Stored as a number under the hood, so you can subtract dates; right-aligned
Currency	`$64.20`	A number wearing a currency format — still fully calculable
Percentage	`25%`	A number where `25%` is stored as `0.25` and shown with a percent sign
Boolean	`TRUE`, `FALSE`	A logical yes/no value, often produced by formulas; centered by default

💡 Alignment is a free type-checker

Here's a habit that will save you hours: numbers and dates right-align; text left-aligns. So if you type 100 and it sits on the left, Sheets is telling you it read it as text, not a number — and it won't add up. A quick glance at which side a value hugs tells you its real type before you ever write a formula. (You can override alignment for looks, but by default it's an honest signal.)

The leading-zero and phone-number gotcha

Because Sheets treats numbers as numbers, it drops leading zeros — type an ID like 007 and you'll get 7. Type a phone number like 0123 456 789 and it may mangle it into something arithmetic. The fix is to tell Sheets "this isn't a quantity, it's a label": format the cells as plain text first (via Format → Number → Plain text), or start the entry with an apostrophe ' — the apostrophe won't show, but it forces text. Use this for ZIP codes, product codes, phone numbers, and any "number" you'll never do math on.

⚠️ Watch Out

Don't put units or symbols inside a number you want to calculate with — typing 64.20 USD or 3 kg turns the whole cell into text, and it won't sum. Enter the bare number (64.20) and let formatting add the dollar sign or unit for display. Keep the value pure and dress it up separately — that's the golden rule of clean data.

Entering & Editing Data

You already entered a few rows last lesson. Let's sharpen the mechanics so entry and correction feel effortless. There are two distinct actions people confuse at first: replacing a cell's contents and editing them.

Replace: click a cell and just start typing. Whatever you type replaces the entire contents. Fast when you want to overwrite.
Edit in place: double-click the cell (or select it and press F2) to open it for editing, with the cursor inside. Now you can fix a typo without retyping the whole thing — essential once cells hold long text or formulas.

The direction keys from last lesson do double duty during entry: Enter confirms and moves down; Tab confirms and moves right. And the single most reassuring key in the whole application is Ctrl/Cmd + Z — undo. Made a mess? Undo it. Pressed it too many times? Ctrl/Cmd + Y (or Ctrl/Cmd + Shift + Z) redoes. Combined with the version history you met in Lesson 1.2, there is no such thing as a permanent mistake here.

✅ Pro Tip

To put a line break inside a single cell (rather than jumping to the next cell), press Alt + Enter on Windows/ChromeOS or Ctrl/Option + Enter on a Mac. Handy for a two-line note in one cell. And Esc cancels an edit entirely, leaving the cell as it was — your "never mind" key.

⚠️ Important Note: If a cell shows ######## instead of your number, don't panic — the value is fine, the column is just too narrow to display it. Widen the column (we cover how in Section 5) and the number reappears. It's a display hiccup, never lost data.

Fill & Speed: the Fill Handle

Once you've entered a cell, look at its bottom-right corner: there's a tiny blue square called the fill handle. Grab it with your mouse and drag, and Sheets fills the cells you drag across. What it fills depends on what you selected — and this is where it gets genuinely clever.

Copy a value: drag the handle from a single cell and it copies that value (or formula) into every cell you cover. Great for repeating a category down a column.
Continue a series: Sheets recognizes patterns. Type 1 and 2 in two cells, select both, and drag the handle — you get 3, 4, 5… Type Mon and drag to get Tue, Wed, Thu. Type a date and drag to get consecutive dates. Type Jan to get the months.
Extend two-cell steps: enter 5 and 10, select both, drag — Sheets infers the step and gives you 15, 20, 25…

This is one of the biggest real-world time-savers in spreadsheets. Numbering 100 rows, laying out a month of dates, or repeating a label down a column goes from minutes of typing to a single drag.

🧠 Mindset

Spreadsheets reward "describe the pattern once, let the tool repeat it." The fill handle is your first taste of that idea, and it's the same instinct behind formulas later: you're not doing the same work over and over, you're teaching the sheet the pattern and letting it run. Every time you catch yourself about to type something repetitive, pause and ask, "can the sheet do this for me?"

Copy, paste, and paste special

Ordinary copy (Ctrl/Cmd + C) and paste (Ctrl/Cmd + V) work exactly as you'd expect, across cells, ranges, and even between sheets. But there's a sharper tool: Paste special (right-click → Paste special, or Edit → Paste special). It lets you paste only part of what you copied — for example, Values only (the results, not the underlying formulas or formatting) or Format only (copy a cell's look onto other cells without touching their contents). Values only in particular becomes invaluable once you're working with formulas; we'll lean on it in Module 2.

✅ Pro Tip

You can also double-click the fill handle (instead of dragging) to auto-fill down to match the length of the data in the neighboring column — no careful dragging to the exact right row. It's a small move that feels magical the first time a column fills itself to precisely the right length.

Formatting That Matters

Formatting is the difference between a wall of raw numbers and a table people actually want to read. The key idea to hold onto: formatting changes how a value looks, never what it is. Format 0.25 as a percent and it displays 25%, but underneath it's still the number 0.25, fully calculable. This separation — real value vs. display — is why clean data plus good formatting is so powerful.

You'll find these controls in two places: the toolbar (quick buttons for bold, currency, percent, decimals, alignment, borders, and fill color) and the Format menu (the complete set, including Format → Number for every number style). Here are the ones worth knowing early:

Format	What it does	Where to find it
Bold headers	Makes the header row stand out from the data	Toolbar B, or Ctrl/Cmd + B
Currency	Shows a value as money, e.g. `$64.20`	Toolbar currency button, or Format → Number → Currency
Percent	Shows a decimal as a percentage, e.g. `25%`	Toolbar % button, or Format → Number → Percent
Date	Displays a date consistently, e.g. Jan 5, 2026	Format → Number → Date (pick a style)
Decimal places	Adds or removes digits after the point	Toolbar "increase/decrease decimals" buttons
Alignment	Left / center / right within the cell	Toolbar alignment buttons

A few more that make tables readable: text wrapping (Format → Wrapping → Wrap) lets long text show on multiple lines inside a cell instead of spilling or being cut off; borders (the toolbar borders button) draw gridlines around cells to group and separate; and background color (the fill-color / paint-bucket button) shades cells — a light shade behind the header row is a classic, tidy touch.

⚠️ Watch Out — merge cells sparingly

Merging (Format → Merge cells) combines several cells into one big cell — tempting for a title banner across the top. Used lightly on a title, it's fine. But over-merging inside your data area causes real trouble: it breaks sorting, filtering, the fill handle, and many formulas, because those tools expect a clean rectangular grid. Rule of thumb: merge for a decorative title if you must, but never merge cells within a data table you'll sort, filter, or calculate on.

💡 Format the whole column, not one cell

Applying a format? Select the entire column of values first (click the column letter, or select the range) so future entries pick up the format automatically. Formatting cell by cell as you go is tedious and easy to forget — set the column's currency or date format once and everything you type there just looks right.

Making a Table Readable

The final layer is about the table as a whole — the small structural touches that keep it usable as it grows from three rows to three hundred.

Freeze the header row

Scroll down a long list and your headings disappear off the top, leaving you guessing which column is which. Freezing pins rows (or columns) in place so they stay visible while the rest scrolls. Use View → Freeze → 1 row to lock your header row — now it's always on screen. You can freeze columns the same way (handy for a name or ID column on a wide sheet). This one setting makes a real dataset feel dramatically more navigable.

Row height and column width

When content doesn't fit, resize. Hover the line between two column letters until you get a resize cursor, then drag to widen — or double-click that line to auto-fit the column to its widest entry. (Remember the ######## from Section 2? Widening the column is the cure.) Rows resize the same way. A little breathing room makes everything easier to read.

Alternating colors

For longer tables, alternating row colors (Format → Alternating colors) shade every other row, so your eye tracks straight across without slipping to the wrong line. It also automatically styles the header. It's an instant, low-effort way to make a plain grid look polished and professional — we'll use it more as our tables grow.

Put the whole workflow together and it's a simple, repeatable pipeline — the path every clean table travels from raw entry to something readable:

graph LR A["📝 Raw entry
type your data"] --> B["🔤 Set types
numbers · dates · currency"] B --> C["🎨 Format
bold header · align · borders"] C --> D["📌 Freeze & size
pin header · fit columns"] D --> E["✅ Readable table"]

✅ Pro Tip

Do these steps roughly in order and life is easier: get the values and types right first, then apply number formats, then the visual styling, and finally freeze and size. Formatting a table before the data is clean just means redoing it — foundation first, polish last.

🎯 Project: A Clean, Formatted Dataset

Time to turn your starter sheet into something that looks and behaves like a real, professional table. You'll enter a week of realistic data with proper types, then format it end to end. Use your own plan's data if it fits, or follow the budget example below.

🏋️ Enter and format a week of data

Objective: Build a small, correctly-typed dataset and format it into a clean, readable table with a styled, frozen header row.

Instructions (about 20 minutes):

(4 min) In your spreadsheet, make sure row 1 has clear headers (e.g. Date, Category, Description, Amount). Enter at least 7 rows of data below them — a week of budget entries or a week's tasks. Type bare numbers (no $) and real dates.
(3 min) Check your alignment: numbers and dates should hug the right, text the left. If an amount is left-aligned, it was read as text — retype it as a bare number.
(2 min) Use the fill handle at least once — for example, type the first two dates and drag to fill the rest of the week, or number a task-ID column 1, 2, 3…
(3 min) Format the Amount column as Currency and the Date column with a Date format (Format → Number). Select the whole column first so new rows inherit it.
(3 min) Style the header row: make it bold, add a light background color, and optionally center it.
(2 min) Freeze the header row via View → Freeze → 1 row, then scroll to confirm it stays put.
(3 min) Tidy up: double-click column borders to auto-fit widths, and turn on Alternating colors (Format → Alternating colors) for a polished finish.

💡 Hint — a formatted week of budget rows

     A            B           C                 D
1    Date         Category    Description       Amount     <- bold, shaded, FROZEN
2    Jan 2, 2026  Groceries   Weekly shop       $64.20
3    Jan 3, 2026  Transport   Bus pass          $30.00
4    Jan 4, 2026  Dining      Coffee with Sam   $8.50
5    Jan 5, 2026  Utilities   Phone top-up      $15.00
6    Jan 6, 2026  Groceries   Market veg        $22.10
7    Jan 7, 2026  Dining      Lunch out         $12.75
8    Jan 8, 2026  Transport   Taxi home         $18.40

Column A: Date format   |   Column D: Currency format
Header row 1: bold + light fill + frozen (View menu, Freeze, 1 row)

Enter the dates and amounts as plain values, then let formatting add the "Jan 2, 2026" look and the dollar signs. Notice the amounts still add up perfectly — because they're real numbers wearing a currency costume. We'll total them with a formula in the very next module.

✅ Project Completion Checklist

At least 7 rows of correctly-typed data (numbers right-aligned, text left-aligned)
You used the fill handle at least once to extend a series
The Amount column is formatted as currency; dates use a Date format
The header row is bold with a background color and is frozen
Columns are sized to fit, with alternating row colors applied
No units or symbols typed inside numeric cells; no merged cells inside the data

🎯 Quick Quiz

Question 1: You type 150 into a cell and it appears on the left side of the cell. What does that tell you?

Question 2: You format the number 0.25 as a percentage. What is actually stored in the cell?

Best Practices for Data & Formatting

✅ Do's

Enter pure values, format for display. Type 64.20, not $64.20 USD; let currency formatting add the symbol.
Trust alignment as a type check. Right = number/date, left = text. A quick glance catches problems early.
Format whole columns. Set currency/date on the column so new rows inherit it automatically.
Freeze your header row. One setting that pays off every time you scroll.

❌ Don'ts

Don't put text and symbols inside numbers you'll calculate with — it silently breaks the math.
Don't over-merge cells inside a data table — it breaks sorting, filtering, fill, and formulas.
Don't format before the data's clean. Get values and types right first, then style — otherwise you'll redo it.
Don't fear ######## — it's just a narrow column, not lost data. Widen it.

💡 Pro Tips

Force text for codes and phone numbers with a leading apostrophe ' or the Plain text format, so leading zeros survive.
Double-click the fill handle to auto-fill down to the neighboring column's length.
Use Paste special → Values only to paste results without dragging along formatting or formulas.

📓 Learning Journal

Keep a learning journal as you work through this course — a document, a note, or a tab in your own spreadsheet. After each lesson, take a few minutes to write down:

Key concepts you learned
Techniques that clicked for you
Questions or confusion points to revisit
Ideas you want to try in your own sheets
Your progress and feelings about learning this — including where your confidence grew

✍️ This lesson's prompt: Which formatting change made the biggest difference to how readable your table looked — the frozen header, the currency format, the header styling, or the alternating colors? And did the "alignment tells you the type" idea catch any data that was secretly text? Note one habit from this lesson you want to apply automatically from now on.

📝 Lesson Summary

🎓 Key Takeaways

Sheets detects data types — numbers, text, dates, currency, percentages, booleans — and alignment reveals the type: numbers/dates right-align, text left-aligns.
Keep numeric values pure (no symbols or units inside them); force plain text for codes and phone numbers so leading zeros survive.
Edit fast with double-click / F2, move with Enter (down) and Tab (right), and undo anything with Ctrl/Cmd + Z.
The fill handle copies values and continues series (dates, 1-2-3, days) in one drag — describe the pattern once, let the sheet repeat it.
Formatting changes only the display, never the value: apply currency, dates, percent, bold headers, borders, and color, then freeze the header and size columns for a readable table.

🎉 What You've Accomplished

You turned a raw grid into a clean, correctly-typed, professionally formatted table — with a frozen, styled header and sensible number formats. This is the foundation layer of the Cells → Formulas → Views model done right. Because your data is clean and your numbers are real, everything you build on top of it in the coming modules will just work.

❓ Common Questions at This Stage

My amounts won't add up in a formula. What went wrong?

Almost always they're text, not numbers — check the alignment (left-aligned numbers are the tell). Common causes: a currency symbol or unit typed into the cell, a stray space, or a cell formatted as plain text. Re-enter the bare number, and use formatting (not typing) to add any symbols.

Why did my phone number or ID lose its leading zero?

Sheets treated it as a real number, and numbers don't keep leading zeros. Format those cells as Plain text (Format → Number → Plain text) before entering, or start the entry with an apostrophe '. That tells Sheets it's a label, not a quantity.

Is it bad to merge cells? I like how the title looks merged.

A single merged title banner across the top is fine. The problem is merging cells inside your data table — it breaks sorting, filtering, the fill handle, and many formulas, because they expect a clean rectangular grid. Keep the data area unmerged and you'll avoid a lot of future headaches.

🔭 Looking Ahead

In the next lesson — Lesson 2.1: Formula Basics — the sheet starts to calculate. You'll write your first formulas, learn how a formula always begins with = and references cells by address, and total the very budget you just formatted. This is where the "living model" from Lesson 1.1 finally comes alive.

✅ Before the Next Lesson

Make sure your dataset is entered with correct types and formatted (currency, dates, frozen header)
Confirm your amounts are real numbers (right-aligned), ready to be summed
Write your Learning Journal entry for this lesson

📚 Additional Resources

🌟 Encouragement for the Journey

Look at your table now — clean columns, real dates, tidy currency, a header that stays put as you scroll. That's not a beginner's grid anymore; it's a proper dataset. And the best part is what's coming: next lesson these honest numbers start calculating themselves. You've built the foundation right. Onward to formulas. 📊