How to merge cells in Google Sheets
Select the cells you want to combine, then go to Format → Merge cells and pick Merge all, Merge horizontally, or Merge vertically. You can also click the Merge icon in the toolbar. Only the top-left value is kept; other values are discarded. Use merge for titles and labels, not for data you still need to sort or filter.
Steps
-
1
Select a contiguous range of cells.
-
2
Click Format → Merge cells, or the Merge toolbar button.
-
3
Choose Merge all, Merge horizontally, or Merge vertically.
-
4
To undo, select the merged cell and choose Format → Merge cells → Unmerge.
Related tutorials
These videos might help you go deeper on this topic.
How to Merge Cells in Google Sheets
Count Merged Rows
Move Cells to New Row with Formula
Reformat Pasted Cells Automatically
OpenAI API Prompt with Array of Cells
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Merge cells
Merge cells combines a rectangular selection into one display cell. Only the top-left cell value survives; others are...
Open →Unmerge cells
Unmerge splits a merged block back into individual cells. Only the top-left cell keeps the displayed value; other cel...
Open →sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function ...
Open →SORT
SORT reorders rows from an input range and spills the result elsewhere. Source data stays put, unlike Data > Sort ran...
Open →filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fast...
Open →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same he...
Open →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, perce...
Open →TEXTJOIN
TEXTJOIN merges many text values into one string with a delimiter between them. The ignore_empty argument skips blank...
Open →FILTER()
Google Sheets FILTER() function guide
Open →SORT()
Google Sheets SORT() function guide
Open →Related questions
Can i merge cells in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →Can you merge cells in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →How to merge cells on Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →How do i merge cells in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →How to merge cells Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →How to sort by multiple columns in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.