Google Sheets is a powerful tool that offers numerous features to enhance data organization and presentation. One such feature is cell merging, which allows users to combine adjacent cells into a single, larger cell. This capability can be particularly useful for creating tables, headers, and visually appealing layouts.
In this article, we will explore the following methods of merging cells in Google Sheets:
- Merging cells horizontally;
- Merging cells vertically;
- Merging cells belonging to various rows and columns.
How to merge cells horizontally in Google Sheets
In order to merge cells horizontally in Google Sheets, meaning merging cells that belong to the same row, follow the following steps.
Select the cells you want to merge
Click on one of the cells you want to merge and then drag your mouse over the rest of the range of cells you wish to merge.
On the Format menu, click on “Merge horizontally”
At the top, click on the Format menu, then on “Merge cells,” and finally on “Merge horizontally.”
The cells have been merged horizontally
Well done! You have merged the cells belonging to the same row.
How to merge cells vertically in Google Sheets
In order to merge cells vertically in Google Sheets, meaning merging cells that belong to the same column, follow the following steps.
Select the cells you want to merge
Click on one of the cells you want to merge and then drag your mouse over the rest of the range of cells you wish to merge.
On the Format menu, click on “Merge vertically”
At the top, click on the Format menu, then on “Merge cells,” and finally on “Merge vertically.”
The cells have been merged vertically
Well done! You have merged the cells belonging to the same column.
How to merge cells belonging to various rows and columns in Google Sheets
Unlike the aforementioned methods, this one will allow you to simultaneously merge cells that belong to different columns and rows. In order to do so, follow the next steps.
Select the cells you want to merge
Click on one of the cells you want to merge and then drag your mouse over the rest of the range of cells you wish to merge.
On the Format menu, click on “Merge all”
At the top, click on the Format menu, then on “Merge cells,” and finally on “Merge all.”
The cells have been merged
Well done! All the cells you have selected have now been merged into a single cell.
What is Softr
Softr is the easiest way to turn your data into powerful business apps—no code required. Connect to your spreadsheet or database, customize layout and logic, and share with your team or clients.
Join 700,000+ users worldwide, building client portals, internal tools, CRMs, dashboards, project management systems, inventory management apps, and more—all without code.
Join 700,000+ users worldwide, building client portals, internal tools, CRMs, dashboards, project management systems, inventory management apps, and more—all without code.
Get started free
Ariful Islam
Categories
