Cell alignment and wrapping in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing a weekly event schedule.

📋 Request: Your manager wants the event schedule to look neat and easy to read on screen and when printed.

📊 Data: You have a table with event names, dates, times, and descriptions. Some descriptions are long and spill over multiple lines.

🎯 Deliverable: Format the schedule so that all text fits inside cells, aligns properly, and wraps text where needed to improve readability.

Sample Data

Event Name	Date	Time	Description
Team Meeting	2024-07-01	10:00 AM	Discuss project progress and next steps
Client Call	2024-07-02	2:00 PM	Call with client to review contract details and address questions
Workshop	2024-07-03	9:00 AM	Hands-on training session for new software tools
Lunch & Learn	2024-07-04	12:00 PM	Informal session on industry trends and best practices
Board Meeting	2024-07-05	4:00 PM	Quarterly board meeting to discuss company performance and strategy

1

Step 1: Select all cells containing the schedule data (A1:D6).

No formula needed. Use mouse or keyboard to highlight cells A1 to D6.

Expected Result

All schedule cells are selected and ready for formatting.

2

Step 2: Set horizontal alignment of text in columns A and D to 'Left Align' to keep text starting from the left edge.

Format > Align > Left align (or use toolbar button) on selected columns A and D.

Expected Result

Text in Event Name and Description columns aligns to the left inside each cell.

3

Step 3: Set horizontal alignment of text in columns B and C to 'Center Align' to center dates and times.

Format > Align > Center align on selected columns B and C.

Expected Result

Dates and times appear centered horizontally in their cells.

4

Step 4: Enable text wrapping for the Description column (column D) so long text fits inside the cell and breaks into multiple lines.

Select column D, then Format > Text wrapping > Wrap.

Expected Result

Long descriptions wrap inside cells, making all text visible without spilling over.

5

Step 5: Adjust row heights automatically to fit wrapped text by double-clicking the row boundary or letting Sheets auto-adjust.

No formula. Double-click row numbers boundary or let Sheets auto-resize rows.

Expected Result

Rows expand vertically to show all wrapped text fully.

6

Step 6: Set vertical alignment of all cells to 'Middle Align' so text is centered vertically in each cell.

Select all cells A1:D6, then Format > Align > Middle align vertically.

Expected Result

Text in all cells is vertically centered for a balanced look.

Final Result

-------------------------------------------------------------
| Event Name   |   Date    |   Time   |       Description       |
-------------------------------------------------------------
| Team Meeting | 2024-07-01| 10:00 AM | Discuss project progress |
|             |           |          | and next steps          |
-------------------------------------------------------------
| Client Call  | 2024-07-02|  2:00 PM | Call with client to     |
|             |           |          | review contract details |
|             |           |          | and address questions   |
-------------------------------------------------------------
| Workshop    | 2024-07-03 |  9:00 AM | Hands-on training       |
|             |           |          | session for new software|
|             |           |          | tools                   |
-------------------------------------------------------------
| Lunch & Learn| 2024-07-04| 12:00 PM | Informal session on     |
|             |           |          | industry trends and     |
|             |           |          | best practices          |
-------------------------------------------------------------
| Board Meeting| 2024-07-05|  4:00 PM | Quarterly board meeting |
|             |           |          | to discuss company      |
|             |           |          | performance and strategy|
-------------------------------------------------------------

✓Left alignment for event names and descriptions improves readability.

✓Center alignment for dates and times makes schedule easier to scan.

✓Text wrapping in descriptions prevents text from spilling outside cells.

✓Vertical middle alignment balances text placement inside cells.

✓Row heights adjust automatically to show all wrapped text clearly.

Bonus Challenge

Add conditional formatting to highlight events happening on weekends with a light background color.

Show Hint

Use a custom formula with WEEKDAY function to detect weekend dates and apply formatting.