Add to Sheets

Add to Sheets

How to Merge Cells in Google Sheets

Merging cells in Google Sheets is a common task that can help you organize your data more effectively. This guide will show you how to merge cells to create a unified appearance for your data.

Understanding Cell Merging

Basic Steps to Merge Cells

  1. Selecting Cells: Click and drag your mouse to highlight the cells you want to merge.
  2. Merging Cells: Go to the “Format” menu, choose “Merge cells,” and then select your desired merge option (Merge all, Merge horizontally, or Merge vertically).
  3. Confirming Merge: After selecting your merge option, the cells will combine into one larger cell, displaying only the data from the top-left cell if there was any.

Unmerging Cells

Tips for Merging Cells

Advanced Merging Techniques


Merging cells in Google Sheets can be a useful way to format your spreadsheet and make it more readable. Whether you’re creating a title, organizing information, or just looking to improve your spreadsheet’s appearance, knowing how to merge and unmerge cells is a handy skill in Google Sheets.

Try out Add to Sheets for free and start saving time on data entry tasks by saving content to GSheets from the web.

Subscribe to our newsletter for updates

We don't spam.