How to Merge Cells in Google Sheets

To merge cells in Google Sheets, follow these steps:

  1. Select the cells you want to merge. You can select multiple cells by clicking and dragging the mouse pointer over them.
  2. Click on the “Merge cells” button in the toolbar. It’s the button with three rectangular cells merging into one.
  3. Choose how you want the merged text to appear. You have three options:
  • Merge all: This will merge all of the selected cells into one, with the text from each cell appearing in a single merged cell.
  • Merge horizontally: This will merge the selected cells into one row, with the text from each cell appearing in a separate column within the merged row.
  • Merge vertically: This will merge the selected cells into one column, with the text from each cell appearing in a separate row within the merged column.
  1. Click the option that best fits your needs. The selected cells will now be merged accordingly.

Note: When you merge cells in Google Sheets, the text in the top-left cell will be the only text that remains. The text from the other cells will be deleted. If you want to keep the text from all of the cells, make sure to copy and paste the text into the top-left cell before merging the cells.