Level 0 · Getting started & environment

0.4Enter, select & save

Goal: Enter and confirm data, select ranges efficiently and save without loss.

Estimated time: 11 min · self-paced reading · If you only have 5 min: read “The essentials in 30s” + the diagram.

The essentials in 30 seconds

You enter then confirm: Enter moves down one cell, Tab goes right — Excel recognizes the type (number right, text left).
A range is noted start:end (e.g. A1:B10): drag or Shift + arrows, Ctrl + click for non-contiguous cells.
You save in .xlsx: automatic on web/OneDrive, regular Ctrl + S on desktop — .csv loses formulas and formatting.

Running mini-case — Wassim tracks down the fake number that breaks his SUM

Wassim, an accountant in Algiers, types his amounts then =SUM(B2:B10): result 0 even though the amounts are there. Instead of retyping everything at random, he plays the loop: he checks the alignment (his « numbers » are on the left → text), selects the range precisely with the keyboard (Shift + arrows), converts them into real numbers (right-aligned) and saves in .xlsx. The SUM becomes correct again, without going through a .csv that would have erased formulas and formatting. His reflex is born: confirm, type, select, save.

Standalone case for this section: it returns in the course, the diagram, the script and the 48h challenge of section 0.4.

1. Enter and confirm

You click a cell, type, then confirm: Enter (moves down one cell) or Tab (moves right). Excel recognizes the type: a number aligns right, text left, a date becomes a real date. If a number aligns left, it often means Excel took it as text — a useful signal. Wassim always confirms before clicking elsewhere.

2. Select a range

A range is a block of cells noted A1:B10 (top-left to bottom-right corner). You select by dragging, or with the keyboard using Shift + arrows. Ctrl + click adds non-contiguous cells. Selecting well is the basis of calculations and formatting. Wassim targets the exact range of his =SUM before concluding.

3. Save without loss

You save in .xlsx format. On web/OneDrive, saving is automatic; on desktop, use Ctrl + S regularly. Beware of formats that lose features (.csv keeps only raw values, no formulas or formatting). Wassim keeps .xlsx as the standard and exports to .csv only to exchange raw values.

Common misinterpretation: « I click elsewhere without confirming, I save as .csv to keep everything, and a left-aligned number stays a number ». No, triple mistake. You confirm with Enter or Tab before leaving the cell, otherwise the entry may be lost. .csv keeps only raw values: no formulas, no formatting — the standard to keep is .xlsx. And a « number » aligned left is text: =SUM ignores it, hence a total of 0.

Select, type, confirm, then save: Excel's fundamental loop.

Text version of the diagram (SEO / screen readers / translation): 1) Wassim, an accountant in Algiers, enters then confirms: Enter to go down, Tab to go right — and checks the type via alignment (number right, text left). 2) He selects precisely: a range noted start:end like A1:B10, with the keyboard using Shift + arrows, Ctrl + click for non-contiguous cells — the basis of any calculation with =SUM. 3) He saves without loss in .xlsx (automatic on web/OneDrive, Ctrl + S on desktop) and avoids .csv which erases formulas and formatting. Lesson: a fake number aligned left explains a SUM of 0 — you convert, you don't retype at random.

🔎 Concrete example — 🔎 Concrete example — Spotting a « fake number »

Wassim types amounts, but SUM returns 0:

Cells « 1,200 » aligned LEFT  →  Excel reads them as TEXT
→ =SUM(B2:B10) ignores text → 0
Fix: retype as numbers (or convert) → aligned right → correct total

Reading: a left alignment of a « number » is the symptom of disguised text.

Lesson: the data type matters as much as the displayed value.

Section vocabulary

Confirm

Commit an entry with Enter (down) or Tab (right).

Simple example: Wassim types an amount then Enter: the entry is taken into account.

What it is not: clicking elsewhere without confirming.

Reflex: type → confirm → only then click elsewhere.

Range

A block of cells noted start:end, top-left to bottom-right corner.

Simple example: Wassim computes =SUM(B2:B10) over his range of amounts.

What it is not: a single isolated cell.

Reflex: name the exact range before any calculation.

Data type

Number, text or date; drives alignment and calculations.

Simple example: Wassim spots his fake numbers by their left alignment.

What it is not: the mere displayed value.

Reflex: left alignment on a number = text alert.

AutoSave

Continuous save to OneDrive (web and 365).

Simple example: Wassim loses nothing: the web saves his budget by itself.

What it is not: the Ctrl + S habit of offline desktop.

Reflex: on desktop, regular Ctrl + S.

.csv format

Plain text with separated values; loses formulas and formatting.

Simple example: Wassim uses it only to exchange raw values, never as a backup.

What it is not: the .xlsx that keeps everything.

Reflex: .csv = export, not backup.

In practice — In practice — Enter and select cleanly

Enter a column of numbers and confirm with Enter, like Wassim.
Check they align right (so recognized as numbers).
Select the range with the keyboard (Shift + arrows) and compute =SUM(B2:B10).
Save as .xlsx (or check AutoSave on the web).

You enter correctly-typed data, select ranges and save safely.

Step-by-step script — Wassim's loop in 5 min

1) Click B2, type 800, confirm with Enter: repeat down to B10 for your amounts. 2) Check the alignment: every number must be on the right — if an amount is on the left, retype it as a number. 3) Select B2:B10 with the keyboard (Shift + arrows), then write =SUM(B2:B10) in B11. 4) Confirm with Enter and read the total. 5) Save as .xlsx (Ctrl + S on desktop) or check AutoSave on the web — like Wassim, never .csv as a backup.

If SUM gives 0 despite visible amounts, suspect numbers stored as text: that is this section's case.

Copy-paste template — my basic-gesture memo

Enter: click → type → Enter (down) / Tab (right)
Check: number = aligned RIGHT / text = left
Select: range start:end (e.g. B2:B10) — Shift + arrows, Ctrl + click = add
Calculate: =SUM(B2:B10)
Save: .xlsx (auto on web / Ctrl + S desktop) — .csv = export only

Fast entry

Wassim fills his column with the keyboard: type, Enter, type — without touching the mouse.

Precise selection

Wassim targets B2:B10 with Shift + arrows: the exact range, without a stray cell.

Fake number

Total at 0 with visible amounts: Wassim spots the left alignment and converts to numbers.

Safe saving

Wassim keeps .xlsx (formulas included) and exports to .csv only to exchange raw values.

✓ Best practices

Check alignment to verify the type (numbers right).
Select with the keyboard (Shift + arrows) for precision.
Ctrl+S regularly on desktop; auto on the web.

✗ Common pitfalls

Numbers entered as text → wrong calculations.
Saving as .csv and losing formulas/formatting.
Forgetting to confirm (Enter) before clicking elsewhere.

Key takeaways

Confirm: Enter (down) or Tab (right).
Range = start:end (e.g. A1:B10).
Number = right-aligned; text = left (type hint).
Standard format .xlsx; .csv loses formulas and formatting.

48h challenge — apply tomorrow

Play Wassim's loop without cheating: enter a column of amounts, confirm with Enter, check the right alignment, compute =SUM(B2:B10) — then save in .xlsx.

Section exit checklist

I enter and confirm (Enter moves down, Tab goes right).
I select an exact range (A1:B10, Shift + arrows).
I spot a fake number and save in .xlsx without loss.

Self-assessment 1-5: can I enter with the keyboard without leaving the loop?Self-assessment 1-5: have I proven the type (alignment) and the saving (.xlsx)?

← Previous : Interface: ribbon, workbooks, sheets & cells (V3)

Frequently asked questions

Why does my SUM return 0 when there are numbers?

They are probably stored as text (often after a copy-paste or an import). Hint: they align left. You retype them as numbers or convert them, and the sum becomes correct again.

Do I still need to save on the web?

No: Excel for the web and 365 with OneDrive save continuously. In offline desktop, keep the Ctrl+S habit.

Check your understanding

A « number » aligns left and won't enter calculations. Why?

Additional resources (optional, to go further)

📘

Enter data (Microsoft support)

support.microsoft.comEN

Videos « enter select save Excel »

YouTubeEN

Level 0 examFresh, harder questions to test what you've learned