Raw data in a spreadsheet is just numbers and text. Formatting transforms that raw data into a professional, readable document that communicates clearly. This module covers every text formatting tool in Excel — from the most basic font change to rich alignment, indenting, text rotation, and the powerful Format Painter. You will also learn to use the Mini Toolbar for rapid on-the-spot formatting without touching the Ribbon.
Text formatting tools in Excel appear in four places. Knowing where each lives saves time:
| Location | How to Access | Best For |
|---|---|---|
| Home Tab → Font Group | Click the Home tab → look at the Font group (second group from the left) | Most text formatting — font, size, bold, italic, underline, colour, borders, fill colour |
| Home Tab → Alignment Group | Home tab → Alignment group (third from left) | Cell alignment, text wrapping, merging, indenting, text angle |
| Mini Toolbar | Right-click a cell or selected range → appears above the context menu | Quick formatting without moving to the Ribbon — especially useful during data entry |
| Format Cells Dialog | Ctrl+1 — or — right-click → Format Cells — or — click the small dialog launcher ↗ arrow at the bottom-right of the Font group | Full, precise formatting control — all options in one place including advanced borders, patterns, and protection |
Font formatting controls the appearance of text inside cells. Select the cell(s) or the text within a cell before applying any font formatting.
| Formatting | Ribbon Button | Keyboard Shortcut | Use For |
|---|---|---|---|
| Bold | B in Font group | Ctrl+B | Column headers, row totals, key values that need emphasis |
| Italic | I in Font group | Ctrl+I | Notes, annotations, placeholder instructions, foreign terms |
| Underline | U in Font group | Ctrl+U | Total rows, grand totals — accounting convention uses double underline for final totals |
| Double Underline | U dropdown ▼ → Double Underline | Ctrl+Shift+D | Grand totals in financial reports — the accounting standard for final figures |
These are toggles — press the shortcut or button once to apply, press again to remove. A cell can have bold AND italic AND underline simultaneously.
| Colour Use | Convention |
|---|---|
| Header rows | Dark background (navy, dark green, dark grey) with white bold text — high contrast for easy reading |
| Alternating row shading | Very light grey or light blue for every other row — helps the eye track across a wide table. Apply via Table Styles (Module 9) for automatic application. |
| Total rows | Light coloured fill (same as header but lighter) with bold text to visually separate totals from data |
| Input cells | Yellow or light blue fill indicates a cell where the user should enter data — widely used in financial models and forms |
| Warning / Error | Red or orange fill with white text signals an error, overdue item, or value outside acceptable range |
| Colour coding categories | Different departments, products, or regions can each have a distinct colour for quick visual identification |
The Mini Toolbar is a compact floating toolbar that appears automatically when you right-click a cell or select text inside a cell. It contains the most commonly used formatting commands in a small, context-aware panel — right where you are working, without needing to move your eyes or mouse to the Ribbon.
The Mini Toolbar typically contains:
The Format Cells dialog gives you access to every formatting option in Excel in one place. Open it with Ctrl+1 from any selected cell(s).
| Tab | What It Controls |
|---|---|
| Number | How the cell's numeric value is displayed: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom. (Covered in Module 7) |
| Alignment | Horizontal alignment (left, centre, right, fill, justify, centre across selection); Vertical alignment (top, middle, bottom); Text control (Wrap Text, Shrink to Fit, Merge Cells); Text orientation (rotate by degrees); Right-to-left direction |
| Font | Font name, style (Regular, Bold, Italic, Bold Italic), size, underline type, colour, effects (Strikethrough, Superscript, Subscript), preview panel |
| Border | Line style (none through thick, dashed, dotted, double), line colour, and where to apply borders (outline, inside, individual edges). Full border preview. (Covered in Module 7) |
| Fill | Background colour, pattern colour, pattern style (diagonal lines, dots, cross-hatch, etc.), fill effects (gradient fills) |
| Protection | Lock (prevents editing when sheet is protected) and Hidden (hides the formula in the formula bar when the sheet is protected). Both settings take effect only when the sheet is protected via Review → Protect Sheet. (Covered in Module 27) |
Alignment controls where text or numbers are positioned within the cell. Well-applied alignment is a key part of making spreadsheets readable.
| Alignment | Shortcut | Best For |
|---|---|---|
| Align Left | Ctrl+L | Text labels — names, descriptions, categories. Default for text entries. |
| Centre | Ctrl+E | Column headers in a table, short labels, codes, grades, Yes/No values |
| Align Right | Ctrl+R | Numbers — always right-align numbers so decimal points and column positions line up vertically for easy comparison |
| Justify | Format Cells → Alignment | Long text blocks that should stretch to fill the full column width on each line |
| Centre Across Selection | Format Cells → Alignment → Horizontal → Centre Across Selection | Centering a title across multiple columns without merging cells — safer alternative to Merge & Center because it preserves individual cells |
| Alignment | When to Use |
|---|---|
| Top | When rows are tall and you want text anchored at the top of the cell |
| Middle (default) | Most header rows — text sits in the vertical centre of the cell height |
| Bottom | Default for most cells — text sits at the bottom of the cell |
Home → Alignment group contains the three vertical alignment buttons (⏐▬▲, ⏐▬▬, ⏐▲▬) — or use Format Cells → Alignment tab.
Wrap Text allows long content to display on multiple lines within the same cell, instead of overflowing into adjacent cells or being truncated. The row height automatically expands to accommodate all lines.
To force a new line at a specific point within the same cell (instead of letting Excel wrap automatically):
An alternative to Wrap Text: Shrink to Fit automatically reduces the font size to make the content fit within the current column width — no wrapping, no overflow.
Indenting moves text away from the left edge of the cell, creating a visual hierarchy. Widely used in financial statements, account lists, and categorised data.
| INCOME | R 850,000 |
| Sales Revenue | R 720,000 |
| Service Income | R 130,000 |
| EXPENSES | R 540,000 |
| Salaries | R 320,000 |
| Rent | R 120,000 |
| Office Rent | R 84,000 |
| Storage Rent | R 36,000 |
The example above uses indent level 0 for category headers, level 1 for main items, and level 2 for sub-items — creating a clear financial statement layout.
Rotating cell text is useful for narrow column headers in wide tables — rotating labels 45° or 90° allows narrow columns with descriptive headers, saving horizontal space.
| Angle | Use Case |
|---|---|
| 45° (Angle Clockwise) | Diagonal column headers in a comparison matrix or attendance register — compact without becoming hard to read |
| 90° (Rotate Text Up) | Very narrow columns with long descriptive headers — e.g., month names (Jan, Feb...) stacked vertically in a calendar-style layout |
| Vertical Text | Each letter stacked top-to-bottom without rotation — for very narrow label columns |
Merging combines two or more adjacent cells into one larger cell. The most common use is centring a title above a table. However, merging has significant limitations — understanding them prevents serious problems.
| Option | What It Does |
|---|---|
| Merge & Center | Combines selected cells into one and centres the content horizontally |
| Merge Across | Merges each row individually in a multi-row selection — does not merge rows together, only merges across columns within each row |
| Merge Cells | Combines selected cells without applying centre alignment |
| Unmerge Cells | Splits a previously merged cell back into individual cells. The content remains in the top-left cell only; all other cells are blank. |
The Format Painter copies all formatting from one cell (font, size, colour, borders, alignment, number format) and applies it to another cell or range with a single click — one of the most time-saving tools in Excel.
Sometimes you need to remove all formatting from cells — returning them to the plain, unformatted default state — without deleting the cell contents.
| Shortcut | Action |
|---|---|
| Ctrl+1 | Open Format Cells dialog |
| Ctrl+B | Bold |
| Ctrl+I | Italic |
| Ctrl+U | Underline (single) |
| Ctrl+Shift+D | Double Underline |
| Ctrl+5 | Strikethrough |
| Ctrl+L | Align Left |
| Ctrl+E | Centre |
| Ctrl+R | Align Right |
| Ctrl+Shift+> | Increase font size one step |
| Ctrl+Shift+< | Decrease font size one step |
| Alt+Enter | Insert manual line break within a cell |
| Ctrl+Alt+V | Open Paste Special dialog |
| Ctrl+Shift+~ | Apply General number format |
| Ctrl+Shift+$ | Apply Currency format (with 2 decimal places) |
| Ctrl+Shift+% | Apply Percentage format (0 decimal places) |
| Ctrl+Shift+# | Apply Date format (dd-mmm-yy) |
| Ctrl+Shift+@ | Apply Time format (hh:mm AM/PM) |
Q1: You have a header row that is formatted with dark green background, white bold text, and centred content. You need to apply the same formatting to 8 more header rows throughout the spreadsheet. What is the most efficient method?
✓ Click any cell in the correctly formatted header row → double-click the Format Painter button (paint brush) on the Home tab. Double-clicking locks Format Painter on. Now click each of the 8 additional header rows in turn — each one instantly receives the identical formatting (background colour, font colour, bold, alignment). Press Esc when all 8 rows are done to turn off Format Painter. This is far faster than formatting each row individually.
Q2: You typed a title "Quarterly Sales Report" in cell A1 and used Merge & Centre across A1:E1. Now your manager asks you to sort the data by column B, but Excel shows an error. What caused the error and what is the correct solution?
✓ The Merge & Centre in row 1 is causing the sort to fail — Excel cannot sort a range that contains merged cells of different sizes. Solution: unmerge first — select A1:E1 → Home → Merge & Center dropdown → Unmerge Cells. The title moves back to cell A1 alone. Then perform the sort. After sorting, instead of using Merge & Centre again, use the safer alternative: select A1:E1 → Ctrl+1 → Alignment tab → Horizontal: Centre Across Selection. The title appears centred across the range without creating a merged cell, so future sorts will work correctly.
Q3: How do you apply text rotation of exactly 45 degrees to a range of column headers?
✓ Select the header cells → Home → Alignment group → Orientation dropdown (∠) → click "Angle Counterclockwise" for approximately 45°. For exactly 45°: Format Cells (Ctrl+1) → Alignment tab → in the Orientation section, type 45 in the Degrees box (or drag the dial to 45) → OK. The text in the selected cells rotates to exactly 45 degrees above horizontal.
Q4: A cell displays ####### instead of its value. What does this mean and how do you fix it?
✓ ####### means the column is too narrow to display the cell's value in its current format. The content is there — Excel just cannot fit it visually. Fix: widen the column by double-clicking the right border of the column header to AutoFit, or drag the border to make it wider. This happens most often with date or currency values that have been formatted to show long text. It can also occur when a negative date results from a date calculation error.
Q5: You have pasted data from a website and all the text has come in with a blue hyperlink colour, Calibri 10pt, and various font sizes. You want to keep the text content but strip all the formatting back to your spreadsheet's default. What is the quickest way?
✓ Select all the pasted cells → Home → Editing → Clear dropdown → Clear Formats. This removes all formatting (font colour, size, hyperlink style, borders, fill) while keeping the text content intact. Alternatively, before pasting: Ctrl+Alt+V → Values (V) → Enter — pasting as values only strips all formatting at the point of paste. A third option: right-click the destination cell → in the Paste Options icons, choose "Values Only" (the 123 icon).
Q6: In a financial statement, you want the text "Total Revenue" in cell A10 to be indented by two levels to show it is a sub-total under a main category. How do you apply exactly 2 indent levels?
✓ Select cell A10 → click the Increase Indent button in the Home tab Alignment group twice (each click adds one indent level). For precise control: Ctrl+1 → Alignment tab → Indent field → type 2 → OK. The text "Total Revenue" now starts 2 character-widths from the left edge of the cell, visually subordinating it under the main category heading. Add Bold formatting to the main category heading to reinforce the hierarchy.