How to Merge Cells in Google Sheets
Merging cells in Google Sheets combines adjacent cells into one larger cell. This is useful for creating headers, titles, and organizing your spreadsheet layout.
Select the Cells You Want to Merge
Click and drag to select the cells you want to merge. They must be adjacent (next to each other).
Click the Merge Button
In the toolbar, click the "Merge" button (it looks like two arrows pointing together). You can also go to Format > Merge cells in the menu.
💡 The merge button is located next to the text alignment controls.
Choose Your Merge Type
Select "Merge all" to combine all selected cells into one, "Merge horizontally" to merge across columns, or "Merge vertically" to merge down rows.
Adjust Cell Formatting
After merging, the new cell will keep the top-left value. Center-align the text and adjust font size to create a clean header.
Try These Templates
Frequently Asked Questions
Can I unmerge cells?
Yes. Select the merged cell, click the Merge button, and select "Unmerge".
What happens to data in non-primary cells?
Only the top-left value is kept. Other values are discarded when merging.