How to merge and split cells in Google Sheets?

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  merge-symbol. If you click the dropdown arrow instead of the merge button, you’ll see options to merge vertically and horizontally.

merge-cells-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.

split-cells-google-sheets

Watch how to merge and split cells in Google Sheets

To see a video demo of all of Kanbanchi's features right here, please, accept functionality cookies.


More Google Workspace tips from Kanbanchi

Also read: How to add dropdown lists in Google Sheets?

Want to try the power of Kanbanchi and Google Workspace?

Start your free trial