How to merge and split cells in Google Sheets

1 min read

Summary

Merging and splitting cells in spreadsheets allows you to consolidate data across multiple cells into one, improving the layout and making the information easier to read. This feature is particularly useful for creating headers or organizing content in a visually appealing and structured way.

In this article, we will show you how to merge and split cells in Google Sheets. Merging cells can be helpful to format your data and make it more presentable. However, keep in mind that despite improving the aesthetics of your spreadsheet, merging cells will make it trickier to copy, paste, and move data and prevent you from sorting and filtering it.

To merge cells, select more than one cell and click the "Merge cells" icon. If you click the dropdown arrow instead of the merge button, you’ll see options to merge vertically and horizontally.

More Google Workspace tips from Kanbanchi How to add dropdown lists in Google Sheets

When selecting more than one column and row simultaneously, merging vertically will only combine the cells within the same column, and merging horizontally will only merge the cells in the same row. To unmerge cells, select a cell that has been merged and uncheck the Merge button.

How to merge and split cells in Google Sheets

Summary

Want to try the power of Kanbanchi and Google Workspace?

Watch how to merge and split cells in Google Sheets