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 Format in the top menu, then click on the Merge cells option. From the submenu, choose the Merge all option.
Alternatively, click on the Select merge type icon from the toolbar and choose the Merge all option.
- You’ll notice the merged cells as in the image below.
Types of Merge Cells options in Google Sheets
There are three other options available in Google sheets:
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 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 lets you merge all the selected cells and will give you a sizeable merged cell.