0.3Interface: ribbon, workbooks, sheets & cells
The essentials in 30 seconds
- Hierarchy: a workbook (.xlsx) contains sheets (tabs), made of cells — you organize by named sheets.
- Each cell has an A1 address: column (letter) + row (number), e.g. C5 — it is the key to formulas.
- The ribbon organizes tools by tabs; the formula bar shows the real content, the Name box the active address.
Running mini-case — Wassim organizes his budget on three sheets
Wassim, an accountant in Algiers, piled everything onto a single sheet with tabs Sheet1 and Sheet2: he gets lost. He applies the hierarchy: a workbook Budget-2026.xlsx with three named sheets — Data (A1 = headers, A2:D200 = sales), Summary (=SUM(Data!D2:D200)) and Chart. He reads each address in A1 (C5 = column C, row 5), checks the formula bar to see the real content and the Name box to navigate. His workbook becomes readable: data, summary and visualization separated.
Standalone case for this section: it returns in the course, the diagram, the script and the 48h challenge of section 0.3.
1. Workbook ▸ sheets ▸ cells
An Excel file is a workbook. It contains one or more sheets (the tabs at the bottom). Each sheet is a grid of cells. This hierarchy — workbook, sheets, cells — structures all your work: you keep related data on separate sheets of the same workbook. Wassim names his tabs instead of keeping Sheet1 and Sheet2.
2. The A1 address: column + row
Columns use letters (A, B, C…), rows use numbers (1, 2, 3…). The intersection gives the cell's address: A1 = column A, row 1; C5 = column C, row 5. This address is the key to referencing a cell in a formula. Wassim reads C5 without hesitation: column C, row 5.
3. The ribbon: tools by tabs
At the top, the ribbon groups commands by tabs (Home, Insert, Data, Formulas…). The formula bar shows the real content of the selected cell (data or formula). The Name box, left of the formula bar, shows — and lets you reach — the active address. Wassim always checks the formula bar before concluding: the display can hide a formula.
🔎 Concrete example — 🔎 Concrete example — Reading an address and a workbook plan
Wassim's workbook, neatly organized into three sheets:
Workbook « Sales 2026.xlsx »
├─ Sheet « Data » : A1 = headers, A2:D200 = sales
├─ Sheet « Summary » : =SUM(Data!D2:D200)
└─ Sheet « Chart » : visualizationReading: Data!D2:D200 refers to a range on ANOTHER sheet (sheet name + « ! » + range).
Lesson: separating data / summary / visualization on distinct sheets keeps the workbook clear.
Section vocabulary
- Workbook
- The .xlsx file; the container of all sheets.
Simple example: Wassim names his Sales 2026.xlsx.
What it is not: an isolated sheet without a file.
Reflex: one workbook = one topic.
- Sheet
- A tab of the workbook; a grid of cells.
Simple example: Wassim separates Data, Summary and Chart.
What it is not: the whole workbook.
Reflex: name each tab as soon as it is created.
- Address (reference)
- A cell's position: column letter + row number.
Simple example: Wassim targets C5: column C, row 5.
What it is not: a vague « box at the top ».
Reflex: always state the exact address.
- Ribbon
- The top toolbar, organized in tabs.
Simple example: Wassim finds SUM under the Formulas tab.
What it is not: the formula bar.
Reflex: look for the tool by tab, not at random.
- Formula bar
- The area that shows and edits the real content of the active cell.
Simple example: Wassim sees =SUM(Data!D2:D200) there instead of a simple total.
What it is not: the value displayed in the grid.
Reflex: doubt about content? formula bar.
In practice — In practice — Explore a workbook
- Create a workbook and add a second sheet (+ button at the bottom), like Wassim.
- Rename the tabs (double-click): « Data » and « Summary ».
- In Summary, reference a Data cell with the syntax Sheet!Cell.
- Use the Name box to jump straight to cell Z100.
Step-by-step script — organize your workbook like Wassim (5 min)
1) Create a workbook Sales 2026.xlsx then add two sheets with the + button: you have three tabs. 2) Double-click each tab to name them Data, Summary and Chart. 3) In Data, type headers in A1:D1 then a few sales in A2:D5. 4) In Summary, type =SUM(Data!D2:D200): like Wassim, you read another sheet with the !. 5) Click a total cell and read the formula bar, then type Z100 in the Name box to jump there.
If the formula shows an error, check the exact spelling of the sheet name before the !.
Copy-paste template — my workbook plan
Workbook « ___ .xlsx » (e.g. Sales 2026.xlsx)
├─ Sheet « Data » : A1 = headers, A2:D___ = raw data
├─ Sheet « Summary » : =SUM(Data!D2:D___)
└─ Sheet « Chart » : visualization
Rule: named tabs + A1 addresses + formula bar to check.Wassim's budget
Wassim separates Data (amounts) and Summary (=SUM(Data!B2:B12)): the total reads another sheet.
Sales tracking
Wassim isolates raw sales in Data and totals in Summary: each sheet has a role.
Name box
Wassim types Z100 in the Name box: he jumps straight to the address without scrolling.
Checking the real content
A total looks typed? Wassim clicks and reads the formula bar: data or formula, the doubt is cleared.
✓ Best practices
- Organize related data by named sheets.
- Use the address (A1) rather than « the top box ».
- Spot the formula bar to see the real content.
✗ Common pitfalls
- Piling everything onto a single sheet.
- Leaving tabs « Sheet1, Sheet2 » unnamed.
- Confusing the displayed value and the underlying formula.
Key takeaways
- Hierarchy: workbook ▸ sheets ▸ cells.
- Address = column (letter) + row (number), e.g. C5.
- The ribbon groups commands by tabs.
- Cross-sheet reference: SheetName!Cell (e.g. Data!D2).
48h challenge — apply tomorrow
Replay Wassim's plan: three named sheets, a formula =SUM(Data!D2:D200) in Summary, then prove with the formula bar that the total really is a formula.
- I can name the hierarchy workbook ▸ sheets ▸ cells.
- I read an A1 address and a cross-sheet reference (Data!D2).
- I check the real content via the formula bar and the Name box.
Frequently asked questions
How many sheets / cells can a workbook hold?
A modern sheet goes up to 1,048,576 rows and 16,384 columns, and a workbook can have many sheets (memory-limited). In practice, well before those limits, you segment or move to another tool.
What is the « ! » in Data!D2 for?
It separates the sheet name from the cell address: it lets a formula on one sheet read a cell on another sheet of the same workbook.
What does the address « C5 » mean?