Merging cells means combining two or more cells into a single cell. This is used for various purposes, for example, to create a header that is the same for multiple columns. This guide shows you how to quickly merge cells in Google Sheets.
Merge cells in Google Sheets
- Select the cells that you wish to merge. For example, I want to merge the cells A1:B1 to categorize my data.
Select the cells to combine. - Select Format in the top menu, then click on the Merge cells option. From the submenu, choose the Merge all option.
Select Merge cells then Merge all. Alternatively, click on the Select merge type icon from the toolbar and choose the Merge all option.
Select the Merge All from the Select merge type dropdown. - You’ll notice the merged cells as in the image below.
Two Merged Cells in the example.
Types of Merge Cells options in Google Sheets
There are three other options available in Google sheets:
Merge Vertical
Merge Vertical lets you merge multiple columns. Merge Vertical is used when you have values in the first column and want to combine them with the second.
Merge Horizontal
Merge Horizontal lets you merge multiple rows. Merge Horizontal is used when you have values in the first row and want to combine them with the second.
Merge All
Merge All lets you merge all the selected cells and will give you a sizeable merged cell.
