Getting Started with Excel
A tour of the Excel interface — the ribbon, cells, rows, columns, and sheets.
Compatibility: All Excel versions
What You'll Learn
- What rows, columns, and cells are
- How to identify a cell by its address (like B3)
- The difference between a workbook and a worksheet
- How to select a single cell vs. a range
Excel organizes everything into a grid of rows and columns. Each box in the grid is called a cell, and every cell has an address made from its column letter and row number — for example, cell B3 is in column B, row 3.
The Main Parts of the Screen
Across the top is the Ribbon, organized into tabs (Home, Insert, Formulas, Data, and more). Each tab groups related commands. Below that is the Formula Bar, which shows the exact contents of whichever cell is currently selected — this matters because a cell can *display* a calculated result while *containing* a formula, and the Formula Bar is where you see which one you're actually looking at.
A single Excel file is called a workbook, and each workbook can contain multiple worksheets (the tabs along the bottom). Think of a workbook as a binder and each worksheet as one page in it.
Selecting Cells
Click any cell to select it. Click and drag to select a range of cells — a range is written as the first cell and last cell separated by a colon, like A1:A10 (column A, rows 1 through 10).
Common Mistakes
- Confusing the Formula Bar (what a cell contains) with the cell itself (what it displays)
- Typing over a worksheet tab name by accident when trying to switch sheets
Practice Exercise
Open a blank workbook. Click on cell D5, then look at the Name Box (top-left, above column A) to confirm it says D5. Then select the range A1:C4 by clicking and dragging.
Key Takeaways
- A cell address is always column letter, then row number
- A workbook can hold many worksheets
- The Formula Bar shows what a cell actually contains, not just what it shows