Cell alignment and wrapping in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing a product list.

📋 Request: Your manager wants a clean and readable product list where all text fits inside cells without cutting off, and the product descriptions are aligned neatly.

📊 Data: You have a table with product names, categories, and long descriptions that sometimes overflow the cell width.

🎯 Deliverable: Format the product list by aligning text to the center horizontally, top vertically, and enable text wrapping so all descriptions are fully visible.

Sample Data

Product Name	Category	Description
Wireless Mouse	Accessories	Ergonomic wireless mouse with adjustable DPI and long battery life.
USB-C Hub	Accessories	Multi-port USB-C hub with HDMI, USB 3.0, and SD card reader support.
Gaming Laptop	Computers	High performance laptop with dedicated graphics card and fast SSD storage.
Office Chair	Furniture	Comfortable ergonomic office chair with adjustable height and lumbar support.
LED Monitor	Monitors	24-inch full HD LED monitor with slim bezel and anti-glare screen.
External Hard Drive	Storage	Portable 2TB external hard drive with USB 3.1 connectivity and shock resistance.
Wireless Keyboard	Accessories	Sleek wireless keyboard with quiet keys and rechargeable battery.
Desk Lamp	Furniture	LED desk lamp with adjustable brightness and flexible arm.

1

Step 1: Select the entire table range including headers.

Click and drag from the top-left cell to the bottom-right cell of the table.

Expected Result

All cells in the table are selected.

2

Step 2: Set horizontal alignment to center for all selected cells.

On the Home tab, click the 'Center' alignment button in the Alignment group.

Expected Result

Text in all cells is horizontally centered.

3

Step 3: Set vertical alignment to top for all selected cells.

On the Home tab, click the 'Top Align' button in the Alignment group.

Expected Result

Text in all cells is aligned to the top vertically.

4

Step 4: Enable text wrapping for the Description column to show full text inside cells.

Select the Description column cells, then click 'Wrap Text' button in the Alignment group on the Home tab.

Expected Result

Long descriptions wrap to multiple lines inside their cells without overflowing.

5

Step 5: Adjust the row heights to fit the wrapped text.

Select all rows, then double-click the boundary below any selected row number to auto-fit row height.

Expected Result

All rows adjust height so wrapped text is fully visible.

Final Result

-------------------------------------------------------------
| Product Name    | Category    | Description                |
-------------------------------------------------------------
| Wireless Mouse  | Accessories | Ergonomic wireless mouse   |
|                |             | with adjustable DPI and    |
|                |             | long battery life.         |
-------------------------------------------------------------
| USB-C Hub      | Accessories | Multi-port USB-C hub with  |
|                |             | HDMI, USB 3.0, and SD card |
|                |             | reader support.            |
-------------------------------------------------------------
| Gaming Laptop  | Computers   | High performance laptop    |
|                |             | with dedicated graphics    |
|                |             | card and fast SSD storage. |
-------------------------------------------------------------
| Office Chair  | Furniture   | Comfortable ergonomic      |
|               |             | office chair with          |
|               |             | adjustable height and      |
|               |             | lumbar support.            |
-------------------------------------------------------------
| LED Monitor   | Monitors    | 24-inch full HD LED monitor|
|               |             | with slim bezel and        |
|               |             | anti-glare screen.         |
-------------------------------------------------------------
| External Hard | Storage     | Portable 2TB external hard |
| Drive        |             | drive with USB 3.1         |
|              |             | connectivity and shock     |
|              |             | resistance.                |
-------------------------------------------------------------
| Wireless     | Accessories | Sleek wireless keyboard    |
| Keyboard    |             | with quiet keys and        |
|             |             | rechargeable battery.      |
-------------------------------------------------------------
| Desk Lamp   | Furniture   | LED desk lamp with         |
|            |             | adjustable brightness and  |
|            |             | flexible arm.              |
-------------------------------------------------------------

✓All product descriptions are fully visible without cutting off.

✓Text is neatly centered horizontally and aligned to the top vertically for better readability.

✓The table looks clean and professional, making it easier to review product details.

Bonus Challenge

Apply different horizontal alignments for each column: left for Product Name, center for Category, and justify for Description.

Show Hint

Select each column separately and use the alignment buttons on the Home tab. For justify alignment, use 'Distributed' alignment option under Format Cells > Alignment.