Merge and center cells in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant preparing a monthly report.

📋 Request: Your manager wants a clear title centered across the top of the report.

📊 Data: You have a simple sales report table with columns for Product, Quantity, and Sales.

🎯 Deliverable: Create a title that says 'Monthly Sales Report' merged and centered across the top columns.

Sample Data

Product	Quantity	Sales
Apples	50	150
Bananas	30	90
Cherries	20	120

1

Step 1: Select cells A1 to C1 where the title will be placed.

Select cells A1:C1

Expected Result

Cells A1, B1, and C1 are selected.

2

Step 2: Type the title text 'Monthly Sales Report' in cell A1.

Enter text: Monthly Sales Report in A1

Expected Result

Cell A1 contains 'Monthly Sales Report'.

3

Step 3: Use the 'Merge and Center' button on the Home tab to merge cells A1 to C1 and center the text.

Click 'Merge and Center' on the toolbar

Expected Result

Cells A1 to C1 are merged into one cell with the text centered.

Final Result

┌───────────────────────────────┐
│      Monthly Sales Report      │
├─────────┬──────────┬──────────┤
│ Product │ Quantity │  Sales   │
├─────────┼──────────┼──────────┤
│ Apples  │    50    │   150    │
│ Bananas │    30    │    90    │
│ Cherries│    20    │   120    │
└─────────┴──────────┴──────────┘

✓The title 'Monthly Sales Report' is clearly visible and centered across the top.

✓Merging cells helps make the report look neat and professional.

Bonus Challenge

Try merging and centering the title across columns A to D after adding a new column 'Region'.

Show Hint

Insert a new column D with header 'Region' and then select A1:D1 before merging and centering.