Google Sheets Header

Merging cells in Google Sheets is a great way to keep your spreadsheet well-organized and easy to understand. The most common use is for headers to identify content across multiple columns, but regardless of the reason, it's a uncomplicated procedure.

Fire upward your browser and head to the Google Sheets home page. Once there, open up upwards a spreadsheet that contains information that needs merging. Highlight the cells y'all want to merge.

Highlight the cells you want to merge.

Next, click Format > Merge cells and then choose ane of the three options to merge the cells:

  • Merge All:Merges all the cells into one jail cell that spans the entirety of the selection, horizontally and vertically.
  • Merge Horizontally: Merges the selected cells into a row of the selected cells.
  • Merge Vertically: Merges the selected cells into a column of the selected cells.

Click Format > Merge Cells, and then click on a format for the cells.

Depending on the direction the cells are positioned, you lot might not exist able to merge horizontally/vertically. For our instance, because nosotros desire to merge iv horizontal cells, we tin can't merge them vertically.

A prompt volition appear if you lot accept data in all the cells you're trying to merge, notifying you that simply the content in the leftmost cell volition remain afterward you merge the cells. The contents of all the other cells are deleted in the procedure. Click "OK" to proceed.

Click "OK."

Later you select the type of cell merging you want, all of the cells will combine into 1 big prison cell. If yous take data in the first jail cell, it will occupy the entirety of the merged cell.

The new cell will span the length of the selected cells.

At present you can format the text/data in the cell notwithstanding yous desire. Considering our merged cell is a title for the four columns beneath information technology, we'll center align it overtop all of them. Click the Align icon in the toolbar and so click "Center."

If y'all want to unmerge the cells, the process is just equally simple. Select the cell, click Format > Merge Cells, and and then choose "Unmerge."

To unmerge the cell, click the merged cell, and then click Format > Merge cells > Unmerge.

If the cells you previously merged all contained information in them, none of the data that was previously in that location volition exist preserved.

The previously merged cell will return to single cells after you unmerge it.

That'south it. You've successfully merged the cells in your spreadsheet.

The above article may contain chapter links, which assistance support How-To Geek.