Microsoft Excel · Workbook essentials · Beginner
Format Cells and Layout in Microsoft Excel
Format a readable report: alignment, wrapping, borders and styles in Excel with a complete practice example, expected results and recovery checks.
Official documentation reviewed; example logic independently checked; native Excel execution not performed · Editorial standards
Quick answer: Format the header, wrap long notes and reuse a border style so the report stays consistent. Check the longest cell after editing; Wrap Text alone is not a guarantee that every line is visible inside a short row.
Version and platform: Excel 2024 for Windows; Mac and web interfaces not covered. Use a disposable workbook for the exercise.
Enter the report before formatting
In a blank Excel 2024 for Windows worksheet, enter this table at A1:D3:
| Item | Owner | Status | Notes |
|---|---|---|---|
| Budget review | Alex | Open | Confirm the final figures before the monthly meeting |
| Inventory check | Sam | Done | Recount the items with quantity differences |
The aim is a readable two-record report, not a decorative dashboard. Each field has one column and each record one row. Keep the status words as text even if you later add color; a reader should not need to distinguish red from green to understand the result.
Establish a clear hierarchy
- Select A1:D1 and use Home → Font to apply Bold. Choose a light fill and dark font color with strong contrast.
- Select A2:D3 and keep ordinary body text rather than bolding every cell.
- Select the label columns and use the Home alignment controls consistently, such as left alignment for text. Select D2:D3 and apply Wrap Text.
- Adjust column D’s width and row heights until both notes are completely visible. Do not solve overflow by shrinking the text beyond comfortable reading size.
- Select A1:D1 and use the Borders arrow in the Font group to apply a bottom border. This separates headings from records without boxing every cell heavily.
Read the table at the size at which someone will actually use it. The header should be distinct, the notes should show their final words and there should be no merged cells inside the record range. Merging fields to improve appearance makes later data handling less predictable.
Create a reusable border style
Choose Home → Cell Styles → New Cell Style and name it ReportDivider. Select Format, open Border, choose a thin line and a neutral color, and use the bottom-border button in the preview. Confirm with OK.
In Style Includes (By Example), clear the categories you do not want this style to control, leaving the border included. This prevents a border-only style from unintentionally imposing a number format, font or fill. Confirm, then select A1:D1, open Cell Styles and apply ReportDivider.
For a concrete reuse check, enter Follow-up in A5 and Details in D5. Select A5:D5 and apply ReportDivider. Both heading areas should have the same bottom-border treatment. The style should not change the words or impose currency formatting on the text. A saved named style is easier to reuse consistently than manually choosing a subtly different border each time.
Test a longer note and reversible cleanup
Replace D2 with “Confirm the final figures, explain the largest difference, and attach the approved summary before the monthly meeting.” Check that the final word meeting is visible. Increase row height if the wrapped text is still clipped. The changed text should not silently disappear behind a neighboring populated cell.
In the practice copy, select only D2 and choose Home → Clear → Clear Formats. Its text should remain while explicit styling is removed. Do not choose Clear All, which removes content too. Reapply Wrap Text and restore the needed row height. This provides a controlled recovery path when experimental formatting goes wrong.
Save as XLSX and reopen. Check the two long notes, header contrast and the custom style’s availability. If the visual separator is missing, inspect the applied border rather than relying on worksheet gridlines. If the report is cluttered, remove unnecessary emphasis before adding more colors. The cited text-formatting source explicitly lists Excel 2024/2021, so this walkthrough does not present its interface as a verified Microsoft 365 or web procedure.
Official references
Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.