Lesson 2: Format a table
- Drag with the mouse from A1 to C1 (or click A1, then Shift+click C1)
- Click B in the toolbar, or press Ctrl+B
| A | B | C | |
|---|---|---|---|
| 1 | Item | Price | Amount |
| 2 | Shirt | 49.9 | 2 |
| 3 | Pants | 89 | 1 |
| 4 | Socks | 15 | 4 |
| 5 | Hat | 35 | 1 |
| 6 |
- A1:C1 are bold
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Format a table in Excel: select a range of cells, make text bold and format numbers as dollars. Shift+arrow keys extend the selection without a mouse. Formatting only changes how the number looks. The value in the cell is still 49.9.
Explore more: Excel course: all lessons, and Your first formula.