0
0
Google Sheetsspreadsheet~15 mins

Merge cells in Google Sheets - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are an office assistant managing event registrations.
📋 Request: Your manager wants a clean and easy-to-read registration summary sheet with merged headers for better presentation.
📊 Data: You have a list of event attendees with columns for First Name, Last Name, Email, and Registration Type.
🎯 Deliverable: Create a summary table with merged header cells for the column titles to improve readability.
Progress0 / 5 steps
Sample Data
First NameLast NameEmailRegistration Type
JohnDoejohn.doe@example.comStandard
JaneSmithjane.smith@example.comVIP
EmilyJonesemily.jones@example.comStandard
MichaelBrownmichael.brown@example.comStandard
LindaWilsonlinda.wilson@example.comVIP
1
Step 1: Select the header cells from A1 to D1 that contain the column titles.
Click and drag from cell A1 to D1 to highlight these cells.
Expected Result
Cells A1, B1, C1, and D1 are selected.
2
Step 2: Merge the selected header cells into one cell to create a single title.
Click the 'Merge cells' button in the toolbar and choose 'Merge all'.
Expected Result
Cells A1 to D1 merge into one large cell spanning columns A to D.
3
Step 3: Type the title 'Event Registration Summary' into the merged header cell.
Click the merged cell and enter the text: Event Registration Summary
Expected Result
The merged cell displays 'Event Registration Summary' centered across columns A to D.
4
Step 4: Below the merged header, restore the original column headers in row 2 for clarity.
Enter 'First Name' in A2, 'Last Name' in B2, 'Email' in C2, and 'Registration Type' in D2.
Expected Result
Row 2 shows the original column headers clearly under the merged title.
5
Step 5: Copy the attendee data from the original table starting at row 3 under the headers.
Copy rows 2 to 6 from the original data and paste them starting at row 3 under the headers.
Expected Result
Rows 3 to 7 contain the attendee data aligned under the correct headers.
Final Result
-------------------------------------------------
|           Event Registration Summary           |
-------------------------------------------------
| First Name | Last Name | Email               | Registration Type |
-------------------------------------------------
| John       | Doe       | john.doe@example.com| Standard          |
| Jane       | Smith     | jane.smith@example.com| VIP             |
| Emily      | Jones     | emily.jones@example.com| Standard        |
| Michael    | Brown     | michael.brown@example.com| Standard       |
| Linda      | Wilson    | linda.wilson@example.com| VIP             |
-------------------------------------------------
✓Merging cells helps create a clear and attractive title for the data.
✓Restoring column headers below the merged title keeps the data easy to understand.
✓The final table is neat and professional, making it easier for the manager to review registrations.
Bonus Challenge

Try merging only the header cells for 'First Name' and 'Last Name' to create a combined 'Name' header, while keeping 'Email' and 'Registration Type' separate.

Show Hint
Select cells A2 and B2, merge them, and type 'Name'. Leave C2 and D2 as they are.