Merge cells in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does merging cells do in Google Sheets?

Merging cells combines two or more adjacent cells into one bigger cell. It helps to make titles or labels stand out across columns or rows.

beginner

How do you merge cells in Google Sheets?

Select the cells you want to merge, then click the 'Merge cells' button in the toolbar. You can choose to merge all, merge horizontally, or merge vertically.

beginner

What happens to the data in merged cells?

Only the content of the upper-left cell is kept. All other data in the merged cells is deleted.

beginner

Can you merge non-adjacent cells in Google Sheets?

No, you can only merge cells that are next to each other in a continuous block.

beginner

What are the three merge options available in Google Sheets?

1. Merge all: combines all selected cells into one. 2. Merge horizontally: merges cells in each row separately. 3. Merge vertically: merges cells in each column separately.

What is the first step to merge cells in Google Sheets?

A Delete the cells

B Type data in the cells

C Click the 'Format' menu

D Select the cells you want to merge

You must first select the cells you want to merge before using the merge feature.

Which data remains after merging multiple cells?

A Data in the bottom-right cell

B Data in the upper-left cell

C Data in all merged cells

D No data remains

Only the content of the upper-left cell is kept after merging.

Can you merge cells that are not next to each other?

A No, only adjacent cells

B Only if they are in the same row

C Yes, always

D Only if they are in the same column

Merging works only on adjacent cells forming a continuous block.

Which merge option merges cells in each row separately?

A Merge horizontally

B Merge all

C Merge vertically

D Unmerge

'Merge horizontally' merges cells in each row separately.

What happens if you merge cells with different data?

A All data is combined

B An error message appears

C Only the upper-left cell's data remains

D Data is copied to all merged cells

Only the data in the upper-left cell remains; other data is deleted.

Explain how to merge cells in Google Sheets and what happens to the data inside those cells.

Think about the steps and what happens to the content.

Describe the three types of merge options available in Google Sheets and when you might use each.

Consider how cells are combined in rows or columns.