One of the easiest ways to organize your spreadsheet is by merging cells. This makes it easier to label columns and display data. Merging cells is a common task no matter what software you’re using, and we’ve already shown how to do it in Excel. It’s relatively easy to accomplish, but we’re going to show you how to merge cells in Google Sheets.
We’re going to be using a contact list in our example. The goal is to combine the First Name and Last Name cells into one category. Open up your spreadsheet and get ready to follow along!
How to merge cells in Google Sheets:
1. Like many tasks, merging cells starts by highlighting the cells you want to merge. In our example, we’ve highlighted cells A1 and B1.
2. Once you’ve chosen your cells, head to the Format tab which is between Insert and Data.
3. Locate the Merge cells option and open the side menu. You’ll see a total of four options which we’ll break down below.
- Merge all — Combine both vertical and horizontal cells
- Merge horizontally — Only combine horizontally, linking columns
- Merge vertically — Only combine vertically, linking rows
- Unmerge — Return cells to their original states
4. We’ll select merge horizontally as we’re combining the headers for two columns. Merge all would also work, though it’s no different in this case.
Caution: Because we’re combining two cells with text, we get a warning message that reminds us that only the left cell will keep its text. This isn’t a major problem as we’re combining the names anyway and have to change the column text.
5. Once you merge the cells, you’ll see that the left cell has the same text as before. Now we’ll update the label to Name and change the alignment to Center. After all, it doesn’t look quite right to have the text off-balance in a wide cell.
That’s all there is to it! Now that you know how to merge cells in Google Sheets you can always undo the merge with the Unmerge option on the same menu. Of course, there’s still a lot to learn if you want to master Google Sheets.