📗 Excel for Beginners · Lesson 2 of 10
Format a table
Format a table in Excel: select a range of cells, make text bold and format numbers as dollars.
The tasks in this lesson
1. Bold headings
- Drag with the mouse from A1 to C1 (or click A1, then Shift+click C1)
- Click B in the toolbar, or press Ctrl+B
💡 Shift+arrow keys extend the selection without a mouse.
2. Prices in dollars
- Select B2 to B5
- Click $
💡 Formatting only changes how the number looks. The value in the cell is still 49.9.
All lessons
- ✍️ 1. Typing in cellsCells, typing, fixing and deleting
- 🎨 2. Format a tableSelect a range, bold and dollar format
- 🧮 3. Your first formulaMultiply, add and subtract between cells
- ➕ 4. SUM and AVERAGEThe total and the average of a column
- ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
- 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
- 🔀 7. IF: if... then...Pass or fail, and COUNTIF
- ↕️ 8. Sort a tableHigh to low, and alphabetical
- 📊 9. Your first chartA bar chart and a pie chart
- 🏠 10. Project: a family budgetEverything we learned in one sheet