You send two reports with the same data. One is plain, cramped and hard to read. The other has clear headers, aligned numbers, formatted currency, borders and proper spacing. The second report gets trusted faster, even before anyone checks the formulas.

Why formatting matters

Formatting helps people read your report quickly. It separates headings from data, shows whether values are currency or percentages, and makes important numbers easier to scan.

Good formatting should make the report clearer. It should not distract the reader.

Formatted report example

DateRegionProductSalesProfit %
2026-07-01WestLaptop Stand₹2,250.0022%
2026-07-02NorthWireless Mouse₹5,200.0018%

Header formatting

The header row should stand out. Common header formatting includes bold text, background fill color, centered alignment and a bottom border.

Keep header names short and meaningful. Use Total Sales instead of a long sentence-like heading.

Number formats

Formatting numbers correctly is critical. The same value can mean different things depending on its format.

  • Number: 1500
  • Currency: ₹1,500.00
  • Percentage: 15%
  • Date: 01-Jul-2026
Important: Formatting changes how a value looks, not necessarily what the value is. A number formatted as currency is still a number.

Alignment

Text is usually easier to read when left-aligned. Numbers are usually easier to compare when right-aligned. Headers often work well when centered.

TextUsually left aligned
₹Currency format
%Percentage format

Column width and AutoFit

If text is cut off or numbers show as ####, the column is too narrow. You can drag the column boundary or double-click between column letters to AutoFit.

AutoFit automatically adjusts a column or row to fit the largest visible content.

💡
Professional habit: Use one header color, one highlight color and one warning color. Consistency makes your report look intentional.
⚠️
Common mistake: Using formatting to hide messy data. Clean the data first, then format it.
🧪 Practice Lab

Format a sales report

Download one ZIP file containing the practice workbook, challenge workbook, solution workbook, cheat sheet, quiz and answer key.

📦 Download Lesson 5 ResourcesWorks as a standalone file and after website deployment

Mini practice

  1. Create a table with Date, Region, Product, Sales and Profit %.
  2. Make the header row bold with fill color.
  3. Format Sales as Currency.
  4. Format Profit % as Percentage.
  5. Apply borders and AutoFit columns.

Quick quiz

  1. Why is formatting important?
  2. What should you do when Excel shows ####?
  3. Should you type currency symbols manually?
  4. What format should Profit % use?

Answers: Improves readability; widen column or AutoFit; no, apply Currency format; Percentage format.

FAQ

The column is too narrow to display the value. Increase the column width or use AutoFit.
Usually no. Formatting changes display. For example, 0.15 can be displayed as 15% but the underlying value remains 0.15.