Merging Cells in Google Docs and Excel: A Step-by-Step Guide

Merging cells in Google Docs or Excel is a straightforward process. In Google Docs, you can merge cells in a table by right-clicking and selecting “Merge cells.” In Excel, you can select the cells you want to merge, navigate to the “Home” tab, and click “Merge & Center.”

After completing the action of merging cells, the selected cells will become a single larger cell. This can be particularly useful for formatting purposes, such as creating a header or title that spans across multiple columns.


Merging cells is a handy feature in spreadsheet and document applications like Google Docs and Excel. It allows you to combine two or more adjacent cells into one larger cell, which can be used for a variety of purposes from aesthetic to functional. Whether it’s creating a neat and organized table, emphasizing a particular section, or simply making your data look more appealing, merging cells can be quite beneficial.

This feature is not only important for professionals who deal with data daily, such as accountants or analysts but also for students, teachers, and anyone who uses these applications for work or personal projects. Learning how to merge cells properly can save you time and make your documents look more professional. Let’s dive into how you can do just that.

Step by Step Tutorial on Merging Cells

Before we get into the steps, it’s worth noting that merging cells can help you create visually appealing and organized documents and spreadsheets. It can emphasize titles, headers, or other important information.

Step 1: Select the cells you want to merge

Click and drag to highlight the cells you wish to combine.
Selecting the correct cells is crucial because once merged, it’s not as simple to separate them without losing data.

Step 2: Right-click and choose ‘Merge cells’ in Google Docs or ‘Merge & Center’ in Excel

In Google Docs, right-click the selected cells and click on “Merge cells.” In Excel, go to the “Home” tab and click “Merge & Center.”
The merging process is different in Google Docs and Excel, so make sure you follow the correct method for the application you’re using.


Organized layoutMerging cells helps in creating a cleaner and more organized appearance, which is essential for presenting data effectively.
Emphasizes important informationBy merging cells, you can make titles, headings, or key data stand out, helping readers to easily identify crucial information.
Flexible formattingMerging cells gives you more control over the layout and formatting of your document or spreadsheet, allowing for more customization.


Loss of individual cell functionalityOnce cells are merged, you can no longer manage them individually, which might be limiting in some scenarios.
Difficulty in data sortingMerged cells can complicate sorting and filtering data since they disrupt the grid structure of the spreadsheet.
Potential for data lossIf not done carefully, merging cells can lead to accidental data loss, especially if the cells contain different data.

Additional Information

Merging cells is a useful feature in both Google Docs and Excel, but it should be used judiciously. Overuse can make a document or spreadsheet challenging to navigate or edit in the future. Remember, once cells are merged, you can’t simply click to unmerge them. You will have to select the merged cell and re-split it into separate cells, which could result in data loss if not done carefully.

Additionally, consider the implications of merging cells when sharing documents with others. Ensure that the merged cells do not obstruct the document’s purpose or make it difficult for others to work with the spreadsheet. Always keep your audience in mind when formatting.


  1. Select the cells you want to merge.
  2. Right-click and choose ‘Merge cells’ in Google Docs or ‘Merge & Center’ in Excel.

Frequently Asked Questions

Can I unmerge cells after merging them?

Yes, you can unmerge cells by selecting the merged cell and choosing “Unmerge cells” or “Merge & Center” again to toggle it off.

Will merging cells delete the data in those cells?

If the cells contain different data, merging will keep the upper-leftmost cell’s data and discard the rest. Always ensure you’re not losing important data before merging.

Can I merge cells across different rows and columns?

Yes, you can merge cells both vertically and horizontally as long as they are adjacent.

Is it possible to merge cells in Google Sheets like in Excel?

Yes, Google Sheets also offers the ability to merge cells similarly to Excel.

Can I merge cells in Google Docs if the table is imported from Google Sheets?

Yes, you can merge cells in Google Docs even if the table is imported from Google Sheets. The process remains the same.


Merging cells in Google Docs and Excel can significantly enhance the presentation and organization of your documents and spreadsheets. While this feature offers several benefits, including a more organized layout and the ability to emphasize important information, it also comes with drawbacks such as loss of individual cell functionality and potential data loss.

Always use the merge function wisely and sparingly to avoid complicating your work. When done correctly, merging cells is a powerful tool that can make your data stand out and convey information effectively. So the next time you’re working on a spreadsheet or a document, give merging cells a try—but remember, always merge with caution!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy