The Foundation
Picture a giant chessboard, or the attendance register your teacher opens each morning. Down the side are numbers for every row; across the top are letters for every column. Each little square sits where one letter meets one number — and that is exactly what a spreadsheet is.
When you open Excel you get a workbook (the whole file, like a notebook). Inside it are worksheets — the tabs along the bottom, like separate pages. Each sheet is a grid of cells. The strips of letters (A, B, C…) are columns that run up and down; the numbers (1, 2, 3…) are rows that run side to side.
Every cell has an address: its column letter first, then its row number. The very first cell, top-left, is A1. One step right is B1; one step down is A2. So B3 means column B, row 3 — just like telling a friend at the cinema to take row B, seat 3. Say the letter, then the number, and you can point to any square on the sheet.
Two helpers sit just above the grid. On the left is the Name Box: it always shows the address of the cell you have clicked, and you can type an address into it to jump straight there. To its right is the long Formula Bar, which shows what is really inside the selected cell. This matters — a cell can show ₹500 yet actually hold a formula that worked it out. The grid shows the answer; the Formula Bar shows the recipe.
Visual Architecture
Two quick pictures: a mind-map of everything in this module, and a flowchart for when a formula stubbornly refuses to calculate.
View Mermaid.js source
mindmap
root((Grid Basics))
Cells and references
Cell address A1
Rows and columns
Name Box
Typing data
Text goes left
Numbers go right
Dates
First formulas
Start with equals
Plus minus times divide
SUM
Formatting
Rupees and percent
Freeze panes
Absolute refs with F4View Mermaid.js source
flowchart TD
A[Formula not calculating] --> B{Did you start with equals}
B -->|No| C[Type the equals sign first]
B -->|Yes| D{Is a cell text not a number}
D -->|Yes| E[Fix the cell so the number sits right]
D -->|No| F{Are the brackets balanced}
F -->|No| G[Match every open bracket]
F -->|Yes| H[Check commas colons and ranges]The Deep Dive
1 · Typing text, numbers and dates. Click a cell, type, press Enter, and Excel silently decides what you gave it. Words like Mumbai are text and sit on the left. Plain numbers like 250 are numbers and snap to the right — that right-hug is Excel quietly saying I can do maths with this. A date such as 7/8/2026 is really a number in disguise (day 1 is 1 January 1900), so it hugs the right too. If a number ever sits on the left, Excel is treating it as text and will refuse to add it up.
| You type | Excel stores it as | It lands on the |
|---|---|---|
| Kirana | text | left |
| 250 | number | right |
| 7/8/2026 | date (a number) | right |
| 007 typed as '007 | text, leading zero kept | left |
| =2+2 | a formula, shows 4 | right |
2 · Your first formula — the golden rule. A formula always begins with an equals sign. That single key is you telling Excel stop reading, start calculating. Miss it and Excel keeps your text exactly as typed. The four maths keys are + add, - subtract, * times and / divide.
3 · Order of operations (BODMAS). Excel follows school maths: Brackets first, then Orders (powers), then Divide and Multiply, then Add and Subtract. So =10+5*3 gives 25, not 45, because the times happens first. When you want the adding to win, wrap it in brackets: =(10+5)*3 gives 45. Brackets are your steering wheel — and every open bracket needs a matching closing one.
4 · Ranges and your first function, SUM. A range is a block of cells written with a colon: A1:A10 means A1 through A10. Instead of =B2+B3+B4+B5 you write =SUM(B2:B5) — shorter, and it keeps working if the numbers change. SUM is the function you will reach for most. A function is just a ready-made formula with a name and a pair of brackets holding its arguments (the bits it works on).
5 · The fill handle and autofill. Every selected cell has a tiny square at its bottom-right corner — the fill handle. Grab it and drag downward and Excel copies your formula, adjusting the addresses as it travels. Type 1 and 2, select both, drag, and Excel continues 3, 4, 5…. Type Jan and drag to get Feb, Mar, Apr…. Double-click the handle to shoot a formula all the way down beside your data in one tap.
6 · Relative vs absolute references — the big one. This idea separates beginners from confident users, so go slowly. Say the tax rate sits in cell B1 and your prices run down column B from B4 to B6, with answers going in column C. In C4 you type =B4*B1 — price times tax — and get the right number. Feeling clever, you drag the fill handle down. Disaster: C5 becomes =B5*B2 and C6 becomes =B6*B3. Excel helpfully shifted both addresses down a row, but B2 and B3 are empty, so your tax silently vanishes.
The fix is to lock the tax cell so it cannot move. Put a dollar sign before the column letter and before the row number: =B4*$B$1. Now drag down and the price part still travels (B4, B5, B6) while the tax part stays glued to B1 every single time. A reference that moves is relative; a reference that is locked is absolute.
You never have to type the dollars by hand. Click a reference in the Formula Bar and press F4; it cycles through the four combinations:
| Press F4 | Reference becomes | What is locked |
|---|---|---|
| Once | $B$1 | column and row (fully absolute) |
| Twice | B$1 | the row only |
| Three times | $B1 | the column only |
| Four times | B1 | nothing — back to relative |
Here is the safe routine, step by step:
7 · Number formatting. Formatting changes how a number looks, never what it is. Select your cells, then: the ₹ button shows currency; the % button turns 0.25 into 25%; the comma style groups big numbers like 1,00,000; and the two decimal buttons add or trim decimal places. Because the stored value never changes, your maths stays exactly the same underneath.
8 · Freeze, wrap and merge. Freeze Panes (on the View tab) pins your heading row so it stays on screen as you scroll — priceless for long lists. Wrap Text lets a long label sit on several lines inside one cell instead of spilling over. Merge glues cells into one; it looks tidy for a title but quietly breaks sorting, selecting and formulas, so keep it for headings only.
9 · Keyboard essentials. A handful of keys save hours:
| Keys | What it does |
|---|---|
| Ctrl + C / Ctrl + V | copy / paste |
| Ctrl + Z | undo the last thing |
| Ctrl + arrow | jump to the edge of your data |
| Ctrl + Shift + arrow | select all the way to the edge |
| Ctrl + ; | drop in today's date |
Expert Traps & Hacks
Almost every beginner hits the same handful of snags. Spot them once and you will never lose an hour to them again.
Interactive Sandbox — Formula Sandbox
Type a formula into the bar and press Run. The cell fills with your answer and turns green the moment it matches. Start gentle with SUM, finish with a two-step tax total.