Borders and shading in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing monthly expense reports.

📋 Request: Your manager wants a clear and easy-to-read expense report with borders around each cell and shading for header rows to improve readability.

📊 Data: You have a table listing expense categories, amounts, and dates for the month.

🎯 Deliverable: Create a formatted expense report with borders around all cells and a shaded header row.

Sample Data

Category	Amount	Date
Office Supplies	150	2024-06-01
Travel	300	2024-06-05
Meals	120	2024-06-10
Utilities	200	2024-06-15
Software	400	2024-06-20
Maintenance	180	2024-06-25

1

Step 1: Select the entire data range including headers (cells A1:C7).

No formula needed; just select cells A1 to C7.

Expected Result

The range A1:C7 is selected.

2

Step 2: Apply borders to all selected cells.

Go to the Home tab, click the Borders dropdown, and select 'All Borders'.

Expected Result

All cells in the range A1:C7 have borders around them.

3

Step 3: Shade the header row to distinguish it from data rows.

Select cells A1:C1, then go to Home tab, click Fill Color, and choose a light gray color.

Expected Result

The header row (A1:C1) is shaded light gray.

4

Step 4: Adjust column widths to fit content for better readability.

Select columns A to C, then double-click the right edge of any selected column header.

Expected Result

Columns A, B, and C adjust width to fit their content.

Final Result

---------------------------------
| Category       | Amount | Date       |
---------------------------------
| Office Supplies| 150    | 2024-06-01 |
| Travel         | 300    | 2024-06-05 |
| Meals          | 120    | 2024-06-10 |
| Utilities      | 200    | 2024-06-15 |
| Software       | 400    | 2024-06-20 |
| Maintenance    | 180    | 2024-06-25 |
---------------------------------

✓Borders make each cell distinct and easy to read.

✓Shading the header row helps quickly identify column titles.

✓Adjusting column widths prevents text from being cut off.

Bonus Challenge

Add alternating row shading (banded rows) to improve readability further.

Show Hint

Use Conditional Formatting with a formula like =MOD(ROW(),2)=0 to shade every other row.