Format Borders & Numbers

Make your data look clean with borders. Show numbers as money or percentages.

Part 1: Borders

Borders are lines around cells. They make tables easier to read.

Add Borders

Step 1: Select your cells

Step 2: Go to Home tab

Step 3: Click the Borders button (small grid icon)

Step 4: Pick a border style

Border Options

Best Practice

Use All Borders for data tables.

Use Thick Box Border around headers.

---

Part 2: Number Formats

Numbers can look different ways:

• 1000 → plain number
• $1,000 → currency
• 50% → percentage
• 12/25/2024 → date

Where to Find It

Home tab → Number group

Format as Currency ($)

1. Select cells with numbers
2. Click $ button

Or press Ctrl + Shift + 4

Format as Percentage (%)

1. Select cells
2. Click % button

Or press Ctrl + Shift + 5

Note: 0.5 becomes 50%

Add Comma (1,000)

1. Select cells
2. Click Comma button

This adds commas: 1000 → 1,000

Increase/Decrease Decimals

Use these buttons:

---

Quick Shortcuts

---

Summary

Borders:

• Select cells → Home → Borders button
• Use "All Borders" for tables

Numbers:

• $ button for currency
• % button for percentage
• Use shortcuts to be faster!