Locked lesson.
About this lesson
In this lesson, we'll cover how to merge and unmerge cells.
Exercise files
Download this lesson’s related exercise files.
23 - Merge cells and Unmerge Cells.docx57.2 KB 23 - Merge cells and Unmerge Cells SOLUTION.docx
55.6 KB
Quick reference
Merge cells and Unmerge Cells
In this video, I'll show you how to merge and unmerge cells.
When to use
Use this whenever you want to merge or unmerge a number of cells in an Excel Spreadsheet.
Instructions
# Merge Cells
ws.merge_cells("A2:B5")
# Unmerge Cells
ws.unmerge_cells("A2:B5")
Hints & tips
- ws.merge_cells("A2:B5")
- ws.unmerge_cells("A2:B5")
Lesson notes are only available for subscribers.