Merge cells in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to merge cells A1 to B1 in Google Sheets using Apps Script.

Google Sheets

sheet.getRange('A1:B1').[1]();

Drag options to blanks, or click blank then click option'

AmergeAcross

Bmerge

CmergeVertically

DmergeCells

Attempts:

3 left

💡 Hint

Common Mistakes

Using mergeAcross merges cells only horizontally but not fully.

Using mergeVertically merges cells vertically, not the full range.

mergeCells is not a valid method.

The merge() method merges all cells in the specified range into one cell.

2fill in blank

medium

Complete the code to merge cells horizontally across columns in the range A2 to D2.

Google Sheets

sheet.getRange('A2:D2').[1]();

Drag options to blanks, or click blank then click option'

AmergeAcross

BmergeCells

CmergeVertically

Dmerge

Attempts:

3 left

💡 Hint

Common Mistakes

Using merge merges all cells into one, not just horizontally.

Using mergeVertically merges cells vertically, not horizontally.

The mergeAcross() method merges cells horizontally across columns but keeps rows separate.

3fill in blank

hard

Fix the error in the code to merge cells vertically in the range B3 to B6.

Google Sheets

sheet.getRange('B3:B6').[1]();

Drag options to blanks, or click blank then click option'

Amerge

BmergeAcross

CmergeVertically

DmergeCells

Attempts:

3 left

💡 Hint

Common Mistakes

Using mergeAcross merges horizontally, not vertically.

Using merge merges all cells into one, not just vertically.

The mergeVertically() method merges cells vertically in the specified range.

4fill in blank

hard

Fill both blanks to merge cells in range C4 to E5 and then unmerge them.

Google Sheets

sheet.getRange('C4:E5').[1](); sheet.getRange('C4:E5').[2]();

Drag options to blanks, or click blank then click option'

Amerge

BbreakApart

CmergeAcross

DmergeVertically

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to unmerge with mergeAcross or mergeVertically.

Using mergeAcross instead of merge for full merge.

First, merge() merges the cells fully, then breakApart() separates them back.

5fill in blank

hard

Fill all three blanks to merge cells A7 to B8 horizontally, then vertically, then unmerge them.

Google Sheets

sheet.getRange('A7:B8').[1](); sheet.getRange('A7:B8').[2](); sheet.getRange('A7:B8').[3]();

Drag options to blanks, or click blank then click option'

AmergeAcross

BmergeVertically

CbreakApart

Dmerge

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up merge and mergeAcross methods.

Trying to unmerge before merging.

First, mergeAcross() merges cells horizontally, then mergeVertically() merges vertically, and finally breakApart() separates them.